APPS.PAY_GB_WNU_EDI dependencies on PAY_PAYROLL_ACTIONS

Line 118: from pay_payroll_actions

114: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
115: 'TAX_REF'),1,20) tax_ref,
116: effective_date,
117: business_group_id
118: from pay_payroll_actions
119: where payroll_action_id = pactid;
120:
121: cursor asg_act is
122: select /*+ ORDERED */

Line 251: pay_payroll_actions pay

247: 'TAX_REF'),1,20) tax_ref,
248: effective_date,
249: business_group_id
250: from pay_assignment_actions paa,
251: pay_payroll_actions pay
252: where paa.assignment_action_id = p_assact_id
253: and pay.payroll_action_id = paa.payroll_action_id;
254:
255: cursor csr_person_id is

Line 530: from pay_payroll_actions pact,

526:
527: cursor csr_sender_id is
528: select hoi.org_information11,
529: hoi.org_information1
530: from pay_payroll_actions pact,
531: hr_organization_information hoi
532: where pact.payroll_action_id = p_payroll_action_id
533: and pact.business_group_id = hoi.organization_id
534: and hoi.org_information_context = 'Tax Details References'

Line 574: 'pay_payroll_actions ppa '||

570: BEGIN
571: hr_utility.set_location('Entering: '||l_proc,1);
572: sqlstr := 'select distinct person_id '||
573: 'from per_people_f ppf, '||
574: 'pay_payroll_actions ppa '||
575: 'where ppa.payroll_action_id = :payroll_action_id '||
576: 'and ppa.business_group_id = ppf.business_group_id '||
577: 'order by ppf.person_id';
578: hr_utility.set_location('Leaving: '||l_proc,999);

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

632: select substr(pact.legislative_parameters,
633: instr(pact.legislative_parameters,'VERSION=') + 8,
634: instr(pact.legislative_parameters||' ',' ',instr(pact.legislative_parameters,'VERSION=')+8)
635: - instr(pact.legislative_parameters,'VERSION=') - 8) version
636: from pay_payroll_actions pact where pact.payroll_action_id = pactid;
637:
638: --Bug 9186359:WNU eText report
639: --This piece of code is relevent only for release 12.1.3
640: Cursor csr_is_etext_report IS

Line 642: From pay_payroll_actions pact

638: --Bug 9186359:WNU eText report
639: --This piece of code is relevent only for release 12.1.3
640: Cursor csr_is_etext_report IS
641: Select report_type
642: From pay_payroll_actions pact
643: Where pact.payroll_action_id = pactid;
644:
645: l_is_etext_report varchar2(50);
646: l_request_id fnd_concurrent_requests.request_id%TYPE;

Line 672: from pay_payroll_actions

668: select legislative_parameters para,
669: fnd_number.number_to_canonical(request_id) control_id,
670: report_type,
671: business_group_id
672: from pay_payroll_actions
673: where payroll_action_id = pactid;
674:
675: cursor csr_header_det(p_bus_id number,
676: p_tax_ref varchar2) is

Line 809: from pay_payroll_actions pay,

805: peo.title title,
806: paf.assignment_number emp_no,
807: peo.national_identifier ni_no ,
808: pai.action_information2 old_works_number
809: from pay_payroll_actions pay,
810: pay_assignment_actions paa,
811: per_all_assignments_f paf,
812: per_all_people_f peo,
813: pay_action_information pai