APPS.PAY_GB_EDI_P46_CAR dependencies on PAY_PAYROLL_ACTIONS

Line 236: pay_payroll_actions ppa

232: CURSOR c_chk_archive IS
233: SELECT 'Y' found_flag
234: FROM pay_action_information pai,
235: pay_assignment_actions act,
236: pay_payroll_actions ppa
237: WHERE ppa.report_type = 'P46_CAR_EDI'
238: AND ppa.report_qualifier='GB'
239: AND ppa.report_category ='EDI'
240: AND ppa.action_type = 'X'

Line 289: pay_payroll_actions ppa

285: CURSOR c_chk_archive IS
286: SELECT 'Y' found_flag
287: FROM pay_action_information pai,
288: pay_assignment_actions act,
289: pay_payroll_actions ppa
290: WHERE ppa.report_type IN ('P46_CAR_EDI_V2','P46_CAR_EDI')
291: AND ppa.report_qualifier='GB'
292: AND ppa.report_category ='EDI'
293: AND ppa.action_type = 'X'

Line 341: pay_payroll_actions ppa,

337: substr(org.org_information2 ,1,40) tax_district_name,
338: organization_id,
339: ppa.effective_date
340: FROM
341: pay_payroll_actions ppa,
342: hr_organization_information org
343: WHERE ppa.payroll_action_id = pactid
344: AND org.org_information_context = 'Tax Details References'
345: AND NVL(org.org_information10,'UK') = 'UK'

Line 404: 'pay_payroll_actions ppa '||

400: hr_utility.set_location(l_proc, 30);
401: --
402: sqlstr := 'select distinct person_id '||
403: 'from per_people_f ppf, '||
404: 'pay_payroll_actions ppa '||
405: 'where ppa.payroll_action_id = :payroll_action_id '||
406: 'and ppa.business_group_id = ppf.business_group_id '||
407: 'order by ppf.person_id';
408:

Line 438: pay_payroll_actions ppa,

434: substr(org.org_information2 ,1,40) tax_district_name,
435: organization_id,
436: ppa.effective_date
437: FROM
438: pay_payroll_actions ppa,
439: hr_organization_information org
440: WHERE ppa.payroll_action_id = pactid
441: AND org.org_information_context = 'Tax Details References'
442: AND NVL(org.org_information10,'UK') = 'UK'

Line 501: 'pay_payroll_actions ppa '||

497: hr_utility.set_location(l_proc, 30);
498: --
499: sqlstr := 'select distinct person_id '||
500: 'from per_people_f ppf, '||
501: 'pay_payroll_actions ppa '||
502: 'where ppa.payroll_action_id = :payroll_action_id '||
503: 'and ppa.business_group_id = ppf.business_group_id '||
504: 'order by ppf.person_id';
505:

Line 547: FROM pay_payroll_actions

543: pay_gb_eoy_archive.get_parameter(
544: legislative_parameters,
545: 'END_DATE')) end_date,
546: business_group_id
547: FROM pay_payroll_actions
548: WHERE payroll_action_id = pactid;
549: --
550: CURSOR c_asg IS
551: SELECT /* USE_INDEX(va,PQP_VEHICLE_ALLOCATIONS_F_N1)

Line 1012: FROM pay_payroll_actions

1008: pay_gb_eoy_archive.get_parameter(
1009: legislative_parameters,
1010: 'END_DATE')) end_date,
1011: business_group_id
1012: FROM pay_payroll_actions
1013: WHERE payroll_action_id = pactid;
1014: --
1015: CURSOR c_asg IS
1016: SELECT /* USE_INDEX(va,PQP_VEHICLE_ALLOCATIONS_F_N1)