APPS.PAY_JP_ISDF_RPT dependencies on PAY_PAYROLL_ACTIONS

Line 250: ' pay_payroll_actions pa'||

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

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

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

Line 310: FROM pay_payroll_actions

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

Line 333: from pay_payroll_actions p

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

Line 1413: FROM pay_payroll_actions

1409: l_cur_pact := pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID' );
1410: --
1411: SELECT legislative_parameters
1412: INTO l_legislative_parameters
1413: FROM pay_payroll_actions
1414: WHERE payroll_action_id = l_cur_pact;
1415: --
1416: l_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',l_legislative_parameters));
1417: l_emp_no_opt := pay_core_utils.get_parameter('PRN_EMP_NO',l_legislative_parameters);