APPS.PAY_PAYROLL_CONTACT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 18: pay_payroll_actions pa1

14: --
15: sqlstr := 'select distinct asg.person_id
16: from
17: per_all_assignments_f asg,
18: pay_payroll_actions pa1
19: where pa1.payroll_action_id = :payroll_action_id
20: and asg.business_group_id = pa1.business_group_id
21: order by asg.person_id';
22: --

Line 43: pay_payroll_actions ppa

39: ) is
40: select distinct paf.assignment_id
41: from per_periods_of_service pos,
42: per_all_assignments_f paf,
43: pay_payroll_actions ppa
44: where ppa.payroll_action_id = cp_pactid
45: and ppa.business_group_id = paf.business_group_id
46: and pos.period_of_service_id = paf.period_of_service_id
47: and pos.person_id between cp_stperson and cp_endperson;

Line 118: from pay_payroll_actions ppa

114: --
115: select
116: pay_core_utils.get_parameter('FORM_ID', ppa.legislative_parameters)
117: into l_formula_id
118: from pay_payroll_actions ppa
119: , pay_temp_object_actions toa
120: where ppa.payroll_action_id = toa.payroll_action_id
121: and toa.object_action_id = p_assactid;
122: --

Line 169: l_bus_grp_id pay_payroll_actions.business_group_id%type;

165: is
166: --
167: l_remove_act varchar2(10);
168: cnt_incomplete_actions number;
169: l_bus_grp_id pay_payroll_actions.business_group_id%type;
170: l_leg_code per_business_groups.legislation_code%type;
171: begin
172: --
173: select

Line 182: from pay_payroll_actions ppa,

178: into
179: l_remove_act,
180: l_bus_grp_id,
181: l_leg_code
182: from pay_payroll_actions ppa,
183: per_business_groups pbg
184: where ppa.payroll_action_id = pactid
185: and pbg.business_group_id = ppa.business_group_id;
186: --