APPS.PAY_GB_EOY_MAGTAPE dependencies on PAY_PAYROLL_ACTIONS

Line 726: FROM pay_payroll_actions pact,

722: l_edi_sender_id VARCHAR2(35) := ' ';
723: CURSOR sender_id_cur IS
724: SELECT upper(nvl(org_information11,' ')) edi_sender_id,
725: pact.request_id
726: FROM pay_payroll_actions pact,
727: hr_organization_information hoi
728: WHERE pact.payroll_action_id = p_payroll_action_id
729: AND hoi.org_information_context = 'Tax Details References'
730: AND hoi.org_information1 = g_tax_district_ref||'/'||g_tax_ref_no

Line 746: FROM pay_payroll_actions pact,

742: -- Get the EDI sender id from hr_organization_information
743: edi_submitter_no VARCHAR2(10) := ' ';
744: CURSOR cur_sumbmitter_no IS
745: SELECT nvl(org_information13,' ') edi_submitter_no
746: FROM pay_payroll_actions pact,
747: hr_organization_information hoi
748: WHERE pact.payroll_action_id = p_payroll_action_id
749: AND hoi.org_information_context = 'Tax Details References'
750: AND hoi.org_information1 = g_tax_district_ref||'/'||g_tax_ref_no

Line 1259: from pay_payroll_actions

1255: ln_payroll_action_id NUMBER(9);
1256: --
1257: cursor get_action_eoy_mode(c_payroll_action_id number) is
1258: select report_category
1259: from pay_payroll_actions
1260: where payroll_action_id = c_payroll_action_id;
1261: --
1262: BEGIN
1263: -- Added for nocopy

Line 1374: FROM pay_payroll_actions

1370: -- add_months(to_date('06/04/'||to_char(start_date,'YYYY'),'dd/mm/yyyy'),12)
1371: -- End of BUG 5671777-5
1372: start_year,
1373: effective_date end_year
1374: FROM pay_payroll_actions
1375: WHERE payroll_action_id = p_payroll_action_id;
1376: --
1377: -- Record type 2 placeholders
1378: l_effective_date DATE;