APPS.PAY_GB_WNU_EDI dependencies on PAY_PAYROLL_ACTIONS

Line 113: from pay_payroll_actions

109: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
110: 'TAX_REF'),1,20) tax_ref,
111: effective_date,
112: business_group_id
113: from pay_payroll_actions
114: where payroll_action_id = pactid;
115:
116: cursor asg_act is
117: select /*+ ORDERED */

Line 246: pay_payroll_actions pay

242: 'TAX_REF'),1,20) tax_ref,
243: effective_date,
244: business_group_id
245: from pay_assignment_actions paa,
246: pay_payroll_actions pay
247: where paa.assignment_action_id = p_assact_id
248: and pay.payroll_action_id = paa.payroll_action_id;
249:
250: cursor csr_person_id is

Line 525: from pay_payroll_actions pact,

521:
522: cursor csr_sender_id is
523: select hoi.org_information11,
524: hoi.org_information1
525: from pay_payroll_actions pact,
526: hr_organization_information hoi
527: where pact.payroll_action_id = p_payroll_action_id
528: and pact.business_group_id = hoi.organization_id
529: and hoi.org_information_context = 'Tax Details References'

Line 569: 'pay_payroll_actions ppa '||

565: BEGIN
566: hr_utility.set_location('Entering: '||l_proc,1);
567: sqlstr := 'select distinct person_id '||
568: 'from per_people_f ppf, '||
569: 'pay_payroll_actions ppa '||
570: 'where ppa.payroll_action_id = :payroll_action_id '||
571: 'and ppa.business_group_id = ppf.business_group_id '||
572: 'order by ppf.person_id';
573: hr_utility.set_location('Leaving: '||l_proc,999);

Line 631: from pay_payroll_actions pact where pact.payroll_action_id = pactid;

627: select substr(pact.legislative_parameters,
628: instr(pact.legislative_parameters,'VERSION=') + 8,
629: instr(pact.legislative_parameters||' ',' ',instr(pact.legislative_parameters,'VERSION=')+8)
630: - instr(pact.legislative_parameters,'VERSION=') - 8) version
631: from pay_payroll_actions pact where pact.payroll_action_id = pactid;
632:
633: l_proc CONSTANT VARCHAR2(50) := g_package || 'deinitialization_code';
634: l_counter number;
635: l_wnu_version VARCHAR2(4);

Line 655: from pay_payroll_actions

651: select legislative_parameters para,
652: fnd_number.number_to_canonical(request_id) control_id,
653: report_type,
654: business_group_id
655: from pay_payroll_actions
656: where payroll_action_id = pactid;
657:
658: cursor csr_header_det(p_bus_id number,
659: p_tax_ref varchar2) is

Line 792: from pay_payroll_actions pay,

788: peo.title title,
789: paf.assignment_number emp_no,
790: peo.national_identifier ni_no ,
791: pai.action_information2 old_works_number
792: from pay_payroll_actions pay,
793: pay_assignment_actions paa,
794: per_all_assignments_f paf,
795: per_all_people_f peo,
796: pay_action_information pai