APPS.PAY_PAYKRSOE_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 245: lv_Assignment_Number Per_Assignments_F.Assignment_Number%TYPE;

241: lv_Effective_Date Pay_Payroll_Actions.Effective_Date%TYPE;
242: lv_Payroll_Name Pay_PAyrolls_F.Payroll_Name%TYPE;
243: lv_RunType_Period VARCHAR2(100);
244: lv_Bus_Place hr_organization_information.Org_Information1%TYPE;
245: lv_Assignment_Number Per_Assignments_F.Assignment_Number%TYPE;
246: lvnum NUMBER;
247: lvmesg VARCHAR2(2000);
248: lvsort1 VARCHAR2(50);
249: lvsort2 VARCHAR2(50);

Line 257: Cursor Cur_Per_Assignments_F is

253: Select Payroll_Name
254: From Pay_Payrolls_F
255: Where Payroll_Id = P_PAYROLL_ID;
256:
257: Cursor Cur_Per_Assignments_F is
258: Select Assignment_Number
259: From Per_Assignments_F
260: Where Assignment_Id = P_ASSIGNMENT_ID;
261: begin

Line 259: From Per_Assignments_F

255: Where Payroll_Id = P_PAYROLL_ID;
256:
257: Cursor Cur_Per_Assignments_F is
258: Select Assignment_Number
259: From Per_Assignments_F
260: Where Assignment_Id = P_ASSIGNMENT_ID;
261: begin
262:
263:

Line 325: Open Cur_Per_Assignments_F;

321: End;
322:
323:
324: Begin
325: Open Cur_Per_Assignments_F;
326: Fetch Cur_Per_Assignments_F Into lv_Assignment_Number;
327: Close Cur_Per_Assignments_F;
328:
329: CP_ASSIGN_NUM := lv_Assignment_Number;

Line 326: Fetch Cur_Per_Assignments_F Into lv_Assignment_Number;

322:
323:
324: Begin
325: Open Cur_Per_Assignments_F;
326: Fetch Cur_Per_Assignments_F Into lv_Assignment_Number;
327: Close Cur_Per_Assignments_F;
328:
329: CP_ASSIGN_NUM := lv_Assignment_Number;
330: End;

Line 327: Close Cur_Per_Assignments_F;

323:
324: Begin
325: Open Cur_Per_Assignments_F;
326: Fetch Cur_Per_Assignments_F Into lv_Assignment_Number;
327: Close Cur_Per_Assignments_F;
328:
329: CP_ASSIGN_NUM := lv_Assignment_Number;
330: End;
331: