APPS.PAY_JP_ISDF_RPT dependencies on PAY_PAYROLL_ACTIONS

Line 251: ' pay_payroll_actions pa'||

247: hr_utility.trace ('Entering '||l_proc_name);
248: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
249: p_sqlstr := ' select distinct p.person_id'||
250: ' from per_people_f p,'||
251: ' pay_payroll_actions pa'||
252: ' where pa.payroll_action_id = :payroll_action_id'||
253: ' and p.business_group_id = pa.business_group_id'||
254: ' order by p.person_id ';
255: hr_utility.trace ('Range cursor query : ' || p_sqlstr);

Line 275: CURSOR c_assact(pay_act_id pay_payroll_actions.payroll_action_id%TYPE,trans_stat varchar2)

271: P_START_PERSON_ID number,
272: P_END_PERSON_ID number,
273: P_CHUNK number
274: ) AS
275: CURSOR c_assact(pay_act_id pay_payroll_actions.payroll_action_id%TYPE,trans_stat varchar2)
276: IS
277: SELECT distinct pjiav.assignment_id, pjiav.effective_date
278: FROM per_all_assignments_f paa,
279: per_all_people_f pap,

Line 311: FROM pay_payroll_actions

307: BEGIN
308: --
309: SELECT legislative_parameters
310: INTO l_legislative_parameters
311: FROM pay_payroll_actions
312: WHERE payroll_action_id = P_PAYROLL_ACTION_ID;
313: --
314: l_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',l_legislative_parameters));
315: l_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters));

Line 334: from pay_payroll_actions p

330: END IF;
331: --
332: if g_bg_id is null then
333: Select p.business_group_id into g_bg_id
334: from pay_payroll_actions p
335: where p.payroll_action_id = p_payroll_action_id ;
336: end if ;
337: --
338: IF (g_dummy = -99) THEN

Line 1943: FROM pay_payroll_actions

1939: l_cur_pact := pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID' );
1940: --
1941: SELECT legislative_parameters
1942: INTO l_legislative_parameters
1943: FROM pay_payroll_actions
1944: WHERE payroll_action_id = l_cur_pact;
1945: --
1946: l_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',l_legislative_parameters));
1947: l_emp_no_opt := pay_core_utils.get_parameter('PRN_EMP_NO',l_legislative_parameters);