APPS.PER_PTU_DFF_MIG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 312: -- PAY_ASSIGNMENT_ACTIONS table.

308: -- |--------------------------< action_creation >-----------------------------|
309: -- ----------------------------------------------------------------------------
310: --
311: -- This procedure contains the code required to populate the
312: -- PAY_ASSIGNMENT_ACTIONS table.
313: --
314: ------------------------------------------------------------------------------------
315: PROCEDURE action_creation(pactid in number,
316: stperson in number,

Line 393: SELECT PAY_ASSIGNMENT_ACTIONS_S.NEXTVAL

389: FOR per_rec in csr_process_all(l_business_group_id) LOOP
390: --
391: -- Create the assignment action to represnt the person combination.
392: --
393: SELECT PAY_ASSIGNMENT_ACTIONS_S.NEXTVAL
394: INTO LOCKINGACTID
395: FROM DUAL;
396: --
397: -- insert into pay_assignment_actions.

Line 397: -- insert into pay_assignment_actions.

393: SELECT PAY_ASSIGNMENT_ACTIONS_S.NEXTVAL
394: INTO LOCKINGACTID
395: FROM DUAL;
396: --
397: -- insert into pay_assignment_actions.
398: --
399: hr_nonrun_asact.insact(lockingactid => lockingactid,
400: assignid => -1,
401: pactid => pactid,

Line 416: SELECT PAY_ASSIGNMENT_ACTIONS_S.NEXTVAL

412: FOR per_rec in csr_process_failed(l_business_group_id) LOOP
413: --
414: -- Create the assignment action to represnt the person combination.
415: --
416: SELECT PAY_ASSIGNMENT_ACTIONS_S.NEXTVAL
417: INTO LOCKINGACTID
418: FROM DUAL;
419: --
420: -- insert into pay_assignment_actions.

Line 420: -- insert into pay_assignment_actions.

416: SELECT PAY_ASSIGNMENT_ACTIONS_S.NEXTVAL
417: INTO LOCKINGACTID
418: FROM DUAL;
419: --
420: -- insert into pay_assignment_actions.
421: --
422: hr_nonrun_asact.insact(lockingactid => lockingactid,
423: assignid => -1,
424: pactid => pactid,

Line 1655: -- PAY_ASSIGNMENT_ACTIONS table.

1651: -- |----------------------------< archive_data >------------------------------|
1652: -- ----------------------------------------------------------------------------
1653: --
1654: -- This procedure contains the code required to process each record within the
1655: -- PAY_ASSIGNMENT_ACTIONS table.
1656: -- The procedure performs the actual migration.
1657: --
1658: PROCEDURE archive_data (p_assactid in number,
1659: p_effective_date in date)

Line 1711: FROM PAY_ASSIGNMENT_ACTIONS ASS

1707: FROM PER_PTU_DFF_MAPPING_LINES L
1708: WHERE H.MAPPING_HEADER_ID = L.MAPPING_HEADER_ID))
1709: AND EXISTS
1710: (SELECT 1
1711: FROM PAY_ASSIGNMENT_ACTIONS ASS
1712: WHERE ASS.ASSIGNMENT_ACTION_ID = P_ASSACTID
1713: AND ASS.OBJECT_ID = PPF.PERSON_ID)
1714: ORDER BY PPF.PERSON_ID, PPF.ATTRIBUTE_CATEGORY,
1715: PPF.EFFECTIVE_START_DATE, PPF.EFFECTIVE_END_DATE;

Line 1725: ,pay_assignment_actions paa

1721: --
1722: SELECT pay_core_utils.get_parameter('REPORT_MODE', ppa.legislative_parameters)
1723: INTO l_report_mode
1724: FROM pay_payroll_actions ppa
1725: ,pay_assignment_actions paa
1726: WHERE ppa.payroll_action_id = paa.payroll_action_id
1727: AND paa.assignment_action_id = p_assactid;
1728: --
1729: -- save point.