APPS.PAY_PYUCSLIS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 3156: l_lockingactid pay_assignment_actions.assignment_action_id%TYPE;

3152: endperson in number,
3153: chunk in number) is
3154:
3155: l_temp_person_id per_all_people_f.person_id%TYPE;
3156: l_lockingactid pay_assignment_actions.assignment_action_id%TYPE;
3157: l_business_group_id number;
3158: l_generation_scope varchar2(20);
3159: l_who_to_proc varchar2(20);
3160:

Line 3311: select pay_assignment_actions_s.nextval

3307: THEN
3308:
3309: for perrec in c_actions(pactid, stperson, endperson) loop
3310:
3311: select pay_assignment_actions_s.nextval
3312: into l_lockingactid
3313: from dual;
3314:
3315: if l_temp_person_id is null then

Line 3352: select pay_assignment_actions_s.nextval

3348: ** If terminated people are not selected
3349: ******************************************/
3350: for asgrec in c_actions_prev(pactid, stperson, endperson) loop
3351:
3352: select pay_assignment_actions_s.nextval
3353: into l_lockingactid
3354: from dual;
3355:
3356: if l_temp_person_id is null then

Line 3439: from pay_assignment_actions ass

3435: p_effective_date in date) is
3436:
3437: cursor c_person is
3438: select ass.object_id
3439: from pay_assignment_actions ass
3440: where ass.assignment_action_id = p_assactid;
3441:
3442: l_person_id per_all_people_f.person_id%TYPE;
3443: l_business_group_id number;

Line 3459: pay_assignment_actions paa

3455: pay_core_utils.get_parameter('WHO_TO_PROCESS',
3456: ppa.legislative_parameters)
3457: into l_business_group_id, l_generation_scope, l_who_to_process
3458: from pay_payroll_actions ppa,
3459: pay_assignment_actions paa
3460: where ppa.payroll_action_id = paa.payroll_action_id
3461: and paa.assignment_action_id = p_assactid;
3462:
3463: /*