APPS.PAY_GB_EOY_MAGTAPE dependencies on PAY_PAYROLL_ACTIONS

Line 888: FROM pay_payroll_actions pact,

884: l_edi_sender_id VARCHAR2(35) := ' ';
885: CURSOR sender_id_cur IS
886: SELECT upper(nvl(org_information11,' ')) edi_sender_id,
887: pact.request_id
888: FROM pay_payroll_actions pact,
889: hr_organization_information hoi
890: WHERE pact.payroll_action_id = p_payroll_action_id
891: AND hoi.org_information_context = 'Tax Details References'
892: AND hoi.org_information1 = g_tax_district_ref||'/'||g_tax_ref_no

Line 908: FROM pay_payroll_actions pact,

904: -- Get the EDI sender id from hr_organization_information
905: edi_submitter_no VARCHAR2(10) := ' ';
906: CURSOR cur_sumbmitter_no IS
907: SELECT nvl(org_information13,' ') edi_submitter_no
908: FROM pay_payroll_actions pact,
909: hr_organization_information hoi
910: WHERE pact.payroll_action_id = p_payroll_action_id
911: AND hoi.org_information_context = 'Tax Details References'
912: AND hoi.org_information1 = g_tax_district_ref||'/'||g_tax_ref_no

Line 1456: from pay_payroll_actions

1452: ln_payroll_action_id NUMBER(9);
1453: --
1454: cursor get_action_eoy_mode(c_payroll_action_id number) is
1455: select report_category
1456: from pay_payroll_actions
1457: where payroll_action_id = c_payroll_action_id;
1458: --
1459: BEGIN
1460: -- Added for nocopy

Line 1571: FROM pay_payroll_actions

1567: -- add_months(to_date('06/04/'||to_char(start_date,'YYYY'),'dd/mm/yyyy'),12)
1568: -- End of BUG 5671777-5
1569: start_year,
1570: effective_date end_year
1571: FROM pay_payroll_actions
1572: WHERE payroll_action_id = p_payroll_action_id;
1573: --
1574: -- Record type 2 placeholders
1575: l_effective_date DATE;