APPS.PAY_GB_MOVDED_EDI dependencies on PAY_GB_EOY_ARCHIVE

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

348: 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 *****/
349: l_locked_action_id number;
350: l_exist number;
351: cursor csr_parameter_info is
352: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
353: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
354: effective_date,
355: business_group_id
356: from pay_payroll_actions

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

349: l_locked_action_id number;
350: l_exist number;
351: cursor csr_parameter_info is
352: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
353: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
354: effective_date,
355: business_group_id
356: from pay_payroll_actions
357: where payroll_action_id = pactid;

Line 2411: SELECT substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2407:
2408: --For bugs 9255173 and 9255183
2409: Cursor csr_cp_info
2410: IS
2411: SELECT substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2412: 'TEST'),1,1) test_indicator,
2413: trim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2414: 'TEST_ID'),1,8)) test_id,
2415: report_type

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

2409: Cursor csr_cp_info
2410: IS
2411: SELECT substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2412: 'TEST'),1,1) test_indicator,
2413: trim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2414: 'TEST_ID'),1,8)) test_id,
2415: report_type
2416: FROM pay_payroll_actions
2417: WHERE payroll_action_id = p_payroll_action_id;

Line 2500: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2496: IS
2497: /* Changes for P45PT3 start*/
2498: cursor csr_parameter_info IS
2499: SELECT
2500: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2501: 'TEST'),1,1) test_indicator,
2502: trim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2503: 'TEST_ID'),1,8)) test_id,
2504: report_type

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

2498: cursor csr_parameter_info IS
2499: SELECT
2500: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2501: 'TEST'),1,1) test_indicator,
2502: trim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2503: 'TEST_ID'),1,8)) test_id,
2504: report_type
2505: FROM pay_payroll_actions
2506: WHERE payroll_action_id = pactid;

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

3408: IS
3409:
3410:
3411: cursor csr_parameter_info is
3412: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST_ID'),
3413: pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
3414: /*ppa.effective_date*/
3415: sysdate
3416: from pay_payroll_actions ppa

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

3409:
3410:
3411: cursor csr_parameter_info is
3412: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST_ID'),
3413: pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
3414: /*ppa.effective_date*/
3415: sysdate
3416: from pay_payroll_actions ppa
3417: ,pay_assignment_actions paa