Code is as follows: the cursor in the process of execution for 44 data, but the article 45 data run directly select out, article 45 after confirm the data is correct, could you tell me what the reason, how to solve?

CURSOR Cur_Per_Info (v_Depart_Id IN Number) Is
Select asg. PERSON_ID
The From Per_Assignments_F2 Asg,
Pay_Payroll_Actions Pac,
Pay_Assignment_Actions Aac
Where 1=1
And Pac. Payroll_Action_Id=Aac. Payroll_Action_Id
And Aac. Assignment_Id=Asg. Assignment_Id
And Asg. Payroll_Id=Pac. Payroll_Id
And p_period_name Between
To_Char (Asg) Effective_Start_Date, 'yyyy - mm) And
To_Char (Asg) Effective_End_Date, 'yyyy - mm)
And Pac. Action_Type='R'
And To_Char (Pac) Effective_Date, 'yyyy - mm)=p_period_name
And asg.ORG ANIZATION_ID=v_Depart_Id
And Asg. Primary_Flag='Y'
And Pac. Payroll_Id=61
The Order By Aac. Payroll_Action_Id Asc, Aac Assignment_Action_Id Asc.

CodePudding user response:

Bring out the one in your little see,

Probably problems should be out in the And asg.ORG ANIZATION_ID=v_Depart_Id on this condition,

Send up Per_Assignments_F2 built predicate sentence,

CodePudding user response:

A comparison on both sides of the results, the loss of the record,
Then condition selection, check which condition is to filter the records