APPS.PER_PTU_DFF_MIG dependencies on PAY_PAYROLL_ACTIONS

Line 275: FROM pay_payroll_actions ppa

271: --
272: SELECT pay_core_utils.get_parameter('REPORT_MODE', ppa.legislative_parameters),
273: pay_core_utils.get_parameter('BUSINESS_GROUP_ID', ppa.legislative_parameters)
274: INTO l_report_mode, l_business_group_id
275: FROM pay_payroll_actions ppa
276: WHERE ppa.payroll_action_id = pactid;
277: --
278: IF (l_report_mode = 'ALL') THEN
279: --

Line 284: ,pay_payroll_actions ppa

280: -- Run for all records.
281: --
282: sqlstr := 'SELECT DISTINCT PERSON_ID
283: FROM PER_ALL_PEOPLE_F PPF
284: ,pay_payroll_actions ppa
285: WHERE ppa.payroll_action_id = :payroll_action_id
286: AND PPF.BUSINESS_GROUP_ID
287: = NVL(pay_core_utils.get_parameter(''BUSINESS_GROUP_ID'', ppa.legislative_parameters), PPF.BUSINESS_GROUP_ID)
288: ORDER BY PPF.PERSON_ID';

Line 296: ,pay_payroll_actions ppa

292: -- Run for failed records
293: --
294: sqlstr := 'SELECT DISTINCT PERSON_ID
295: FROM PER_PTU_DFF_MIG_FAILED_PEOPLE PPF
296: ,pay_payroll_actions ppa
297: WHERE ppa.payroll_action_id = :payroll_action_id
298: AND PPF.ERROR_DESCRIPTION <> ''SUCCESS''
299: AND PPF.BUSINESS_GROUP_ID
300: = NVL(pay_core_utils.get_parameter(''BUSINESS_GROUP_ID'', ppa.legislative_parameters), PPF.BUSINESS_GROUP_ID)

Line 326: ,pay_payroll_actions ppa

322: --
323: CURSOR csr_process_all(p_business_group_id number) IS
324: SELECT DISTINCT PPF.PERSON_ID PERSON_ID
325: FROM PER_ALL_PEOPLE_F PPF
326: ,pay_payroll_actions ppa
327: WHERE PPF.PERSON_ID BETWEEN STPERSON AND ENDPERSON
328: AND ppa.payroll_action_id = pactid
329: AND ppf.business_group_id = nvl(p_business_group_id,ppf.business_group_id)
330: AND ppf.business_group_id not in

Line 383: FROM pay_payroll_actions ppa

379: --
380: SELECT pay_core_utils.get_parameter('REPORT_MODE', ppa.legislative_parameters),
381: pay_core_utils.get_parameter('BUSINESS_GROUP_ID', ppa.legislative_parameters)
382: INTO l_report_mode,l_business_group_id
383: FROM pay_payroll_actions ppa
384: WHERE ppa.payroll_action_id = pactid;
385: --
386: -- Run for all
387: --

Line 1724: FROM pay_payroll_actions ppa

1720: -- Get the report mode into local variable.
1721: --
1722: SELECT pay_core_utils.get_parameter('REPORT_MODE', ppa.legislative_parameters)
1723: INTO l_report_mode
1724: FROM pay_payroll_actions ppa
1725: ,pay_assignment_actions paa
1726: WHERE ppa.payroll_action_id = paa.payroll_action_id
1727: AND paa.assignment_action_id = p_assactid;
1728: --

Line 2296: FROM pay_payroll_actions ppa

2292: -- request.
2293: --
2294: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID', ppa.legislative_parameters)
2295: INTO l_business_group_id
2296: FROM pay_payroll_actions ppa
2297: WHERE ppa.payroll_action_id = pactid;
2298: --
2299: open csr_failed_people(l_business_group_id);
2300: fetch csr_failed_people into l_person_id;