APPS.PAY_GB_MOVDED_EDI dependencies on PAY_GB_EOY_ARCHIVE

Line 284: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,

280: l_p46_5_def number; /**** l_p46_5_def : 0 -> no default to be run; 1 -> default for P46_5 to be run; 2 -> default has been run,now the normal P46_5 *****/
281: l_locked_action_id number;
282: l_exist number;
283: cursor csr_parameter_info is
284: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
285: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
286: effective_date,
287: business_group_id
288: from pay_payroll_actions

Line 285: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,

281: l_locked_action_id number;
282: l_exist number;
283: cursor csr_parameter_info is
284: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
285: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
286: effective_date,
287: business_group_id
288: from pay_payroll_actions
289: where payroll_action_id = pactid;

Line 1575: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1571: IS
1572: /* Changes for P45PT3 start*/
1573: cursor csr_parameter_info IS
1574: SELECT
1575: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1576: 'TEST'),1,1) test_indicator,
1577: trim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1578: 'TEST_ID'),1,8)) test_id,
1579: report_type

Line 1577: trim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1573: cursor csr_parameter_info IS
1574: SELECT
1575: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1576: 'TEST'),1,1) test_indicator,
1577: trim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1578: 'TEST_ID'),1,8)) test_id,
1579: report_type
1580: FROM pay_payroll_actions
1581: WHERE payroll_action_id = pactid;

Line 1976: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST_ID'),

1972: IS
1973:
1974:
1975: cursor csr_parameter_info is
1976: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST_ID'),
1977: pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
1978: /*ppa.effective_date*/
1979: sysdate
1980: from pay_payroll_actions ppa

Line 1977: pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),

1973:
1974:
1975: cursor csr_parameter_info is
1976: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST_ID'),
1977: pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
1978: /*ppa.effective_date*/
1979: sysdate
1980: from pay_payroll_actions ppa
1981: ,pay_assignment_actions paa