APPS.PAY_BATCH_LINK_PROCESS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 310: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;

306: -- ---------------------------------------------------------------------------
307: procedure init_ppa
308: (p_payroll_action_id in number)
309: is
310: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
311: --
312: l_null_ppa t_payroll_action_rec;
313: --
314: cursor csr_ppa

Line 327: from pay_payroll_actions ppa

323: ,pay_core_utils.get_parameter
324: ('ELE_LINK_ID', legislative_parameters) ele_link_id
325: ,pay_core_utils.get_parameter
326: ('BAT_LINK_ID', legislative_parameters) bat_link_id
327: from pay_payroll_actions ppa
328: where payroll_action_id = p_payroll_action_id;
329: --
330: l_ppa_rec csr_ppa%rowtype;
331: --

Line 505: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;

501: (p_pact_rec in t_payroll_action_rec
502: ,p_phase in number
503: )
504: is
505: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
506: --
507: l_link t_element_link_rec;
508: l_pg_link pay_asg_link_usages_pkg.t_pg_link_rec;
509: --

Line 556: (select null from pay_payroll_actions

552: -- not processed by this payroll action
553: and nvl(bos.payroll_action_id, -999) <> p_pact_id
554: and (nvl(bos.object_status, 'C') <> 'P'
555: or not exists
556: (select null from pay_payroll_actions
557: where payroll_action_id = bos.payroll_action_id))
558: group by
559: pel.element_link_id
560: ,pel.element_type_id

Line 917: pay_payroll_actions ppa

913: -- include non-emp assignments for ALUs.
914: l_sql :=
915: 'select distinct asg.person_id
916: from
917: pay_payroll_actions ppa
918: ,per_all_assignments_f asg
919: where
920: ppa.payroll_action_id = :payroll_action_id
921: and asg.business_group_id = ppa.business_group_id

Line 931: pay_payroll_actions ppa

927: else
928: l_sql :=
929: 'select distinct asg.person_id
930: from
931: pay_payroll_actions ppa
932: ,per_all_assignments_f asg
933: ,per_periods_of_service pos
934: where
935: ppa.payroll_action_id = :payroll_action_id

Line 1209: from pay_payroll_actions ppa

1205: where paa.payroll_action_id = p_payroll_action_id
1206: and paa.action_status <> 'C')
1207: union all
1208: select ppa.action_status
1209: from pay_payroll_actions ppa
1210: where ppa.payroll_action_id = p_payroll_action_id
1211: ;
1212: --
1213: l_pact_id number;

Line 1227: from pay_payroll_actions

1223: select
1224: pay_core_utils.get_parameter
1225: ('REMOVE_ACT', legislative_parameters) remove_act
1226: into l_remove_act
1227: from pay_payroll_actions
1228: where payroll_action_id = p_payroll_action_id
1229: ;
1230:
1231: open csr_action_status;