APPS.PAY_GB_EDI_P46_CAR dependencies on PAY_GB_EOY_ARCHIVE

Line 826: SELECT to_number( pay_gb_eoy_archive.get_parameter(

822: l_ovn pay_action_information.object_version_number%TYPE;
823: --
824: --
825: CURSOR c_param_values IS
826: SELECT to_number( pay_gb_eoy_archive.get_parameter(
827: legislative_parameters,
828: 'PAYROLL_ID')) payroll_id,
829: substr( pay_gb_eoy_archive.get_parameter(
830: legislative_parameters,

Line 829: substr( pay_gb_eoy_archive.get_parameter(

825: CURSOR c_param_values IS
826: SELECT to_number( pay_gb_eoy_archive.get_parameter(
827: legislative_parameters,
828: 'PAYROLL_ID')) payroll_id,
829: substr( pay_gb_eoy_archive.get_parameter(
830: legislative_parameters,
831: 'TAX_REF'),1,20) tax_ref,
832: start_date,
833: effective_date,

Line 835: pay_gb_eoy_archive.get_parameter(

831: 'TAX_REF'),1,20) tax_ref,
832: start_date,
833: effective_date,
834: fnd_date.canonical_to_date(
835: pay_gb_eoy_archive.get_parameter(
836: legislative_parameters,
837: 'END_DATE')) end_date,
838: business_group_id
839: FROM pay_payroll_actions

Line 1291: SELECT to_number( pay_gb_eoy_archive.get_parameter(

1287: l_ovn pay_action_information.object_version_number%TYPE;
1288: --
1289: --
1290: CURSOR c_param_values IS
1291: SELECT to_number( pay_gb_eoy_archive.get_parameter(
1292: legislative_parameters,
1293: 'PAYROLL_ID')) payroll_id,
1294: substr( pay_gb_eoy_archive.get_parameter(
1295: legislative_parameters,

Line 1294: substr( pay_gb_eoy_archive.get_parameter(

1290: CURSOR c_param_values IS
1291: SELECT to_number( pay_gb_eoy_archive.get_parameter(
1292: legislative_parameters,
1293: 'PAYROLL_ID')) payroll_id,
1294: substr( pay_gb_eoy_archive.get_parameter(
1295: legislative_parameters,
1296: 'TAX_REF'),1,20) tax_ref,
1297: start_date,
1298: effective_date,

Line 1300: pay_gb_eoy_archive.get_parameter(

1296: 'TAX_REF'),1,20) tax_ref,
1297: start_date,
1298: effective_date,
1299: fnd_date.canonical_to_date(
1300: pay_gb_eoy_archive.get_parameter(
1301: legislative_parameters,
1302: 'END_DATE')) end_date,
1303: business_group_id
1304: FROM pay_payroll_actions

Line 1825: SELECT to_number( pay_gb_eoy_archive.get_parameter(

1821: l_ovn pay_action_information.object_version_number%TYPE;
1822: --
1823: --
1824: CURSOR c_param_values IS
1825: SELECT to_number( pay_gb_eoy_archive.get_parameter(
1826: legislative_parameters,
1827: 'PAYROLL_ID')) payroll_id,
1828: substr( pay_gb_eoy_archive.get_parameter(
1829: legislative_parameters,

Line 1828: substr( pay_gb_eoy_archive.get_parameter(

1824: CURSOR c_param_values IS
1825: SELECT to_number( pay_gb_eoy_archive.get_parameter(
1826: legislative_parameters,
1827: 'PAYROLL_ID')) payroll_id,
1828: substr( pay_gb_eoy_archive.get_parameter(
1829: legislative_parameters,
1830: 'TAX_REF'),1,20) tax_ref,
1831: start_date,
1832: effective_date,

Line 1834: pay_gb_eoy_archive.get_parameter(

1830: 'TAX_REF'),1,20) tax_ref,
1831: start_date,
1832: effective_date,
1833: fnd_date.canonical_to_date(
1834: pay_gb_eoy_archive.get_parameter(
1835: legislative_parameters,
1836: 'END_DATE')) end_date,
1837: business_group_id
1838: FROM pay_payroll_actions

Line 2365: SELECT to_number( pay_gb_eoy_archive.get_parameter(

2361: l_ovn pay_action_information.object_version_number%TYPE;
2362: --
2363: --
2364: CURSOR c_param_values IS
2365: SELECT to_number( pay_gb_eoy_archive.get_parameter(
2366: legislative_parameters,
2367: 'PAYROLL_ID')) payroll_id,
2368: substr( pay_gb_eoy_archive.get_parameter(
2369: legislative_parameters,

Line 2368: substr( pay_gb_eoy_archive.get_parameter(

2364: CURSOR c_param_values IS
2365: SELECT to_number( pay_gb_eoy_archive.get_parameter(
2366: legislative_parameters,
2367: 'PAYROLL_ID')) payroll_id,
2368: substr( pay_gb_eoy_archive.get_parameter(
2369: legislative_parameters,
2370: 'TAX_REF'),1,20) tax_ref,
2371: start_date,
2372: effective_date,

Line 2374: pay_gb_eoy_archive.get_parameter(

2370: 'TAX_REF'),1,20) tax_ref,
2371: start_date,
2372: effective_date,
2373: fnd_date.canonical_to_date(
2374: pay_gb_eoy_archive.get_parameter(
2375: legislative_parameters,
2376: 'END_DATE')) end_date,
2377: business_group_id
2378: FROM pay_payroll_actions