APPS.PAY_PYUCSLIS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 6153: l_lockingactid pay_assignment_actions.assignment_action_id%TYPE;

6149: endperson in number,
6150: chunk in number) is
6151:
6152: l_temp_person_id per_all_people_f.person_id%TYPE;
6153: l_lockingactid pay_assignment_actions.assignment_action_id%TYPE;
6154: l_business_group_id number;
6155: l_generation_scope varchar2(20);
6156: l_who_to_proc varchar2(20);
6157:

Line 6308: select pay_assignment_actions_s.nextval

6304: THEN
6305:
6306: for perrec in c_actions(pactid, stperson, endperson) loop
6307:
6308: select pay_assignment_actions_s.nextval
6309: into l_lockingactid
6310: from dual;
6311:
6312: if l_temp_person_id is null then

Line 6349: select pay_assignment_actions_s.nextval

6345: ** If terminated people are not selected
6346: ******************************************/
6347: for asgrec in c_actions_prev(pactid, stperson, endperson) loop
6348:
6349: select pay_assignment_actions_s.nextval
6350: into l_lockingactid
6351: from dual;
6352:
6353: if l_temp_person_id is null then

Line 6436: from pay_assignment_actions ass

6432: p_effective_date in date) is
6433:
6434: cursor c_person is
6435: select ass.object_id
6436: from pay_assignment_actions ass
6437: where ass.assignment_action_id = p_assactid;
6438:
6439: l_person_id per_all_people_f.person_id%TYPE;
6440: l_business_group_id number;

Line 6456: pay_assignment_actions paa

6452: pay_core_utils.get_parameter('WHO_TO_PROCESS',
6453: ppa.legislative_parameters)
6454: into l_business_group_id, l_generation_scope, l_who_to_process
6455: from pay_payroll_actions ppa,
6456: pay_assignment_actions paa
6457: where ppa.payroll_action_id = paa.payroll_action_id
6458: and paa.assignment_action_id = p_assactid;
6459:
6460: /*