APPS.PAY_GB_EDI_P46_CAR dependencies on PAY_GB_EOY_ARCHIVE

Line 534: SELECT to_number( pay_gb_eoy_archive.get_parameter(

530: l_ovn pay_action_information.object_version_number%TYPE;
531: --
532: --
533: CURSOR c_param_values IS
534: SELECT to_number( pay_gb_eoy_archive.get_parameter(
535: legislative_parameters,
536: 'PAYROLL_ID')) payroll_id,
537: substr( pay_gb_eoy_archive.get_parameter(
538: legislative_parameters,

Line 537: substr( pay_gb_eoy_archive.get_parameter(

533: CURSOR c_param_values IS
534: SELECT to_number( pay_gb_eoy_archive.get_parameter(
535: legislative_parameters,
536: 'PAYROLL_ID')) payroll_id,
537: substr( pay_gb_eoy_archive.get_parameter(
538: legislative_parameters,
539: 'TAX_REF'),1,20) tax_ref,
540: start_date,
541: effective_date,

Line 543: pay_gb_eoy_archive.get_parameter(

539: 'TAX_REF'),1,20) tax_ref,
540: start_date,
541: effective_date,
542: fnd_date.canonical_to_date(
543: pay_gb_eoy_archive.get_parameter(
544: legislative_parameters,
545: 'END_DATE')) end_date,
546: business_group_id
547: FROM pay_payroll_actions

Line 999: SELECT to_number( pay_gb_eoy_archive.get_parameter(

995: l_ovn pay_action_information.object_version_number%TYPE;
996: --
997: --
998: CURSOR c_param_values IS
999: SELECT to_number( pay_gb_eoy_archive.get_parameter(
1000: legislative_parameters,
1001: 'PAYROLL_ID')) payroll_id,
1002: substr( pay_gb_eoy_archive.get_parameter(
1003: legislative_parameters,

Line 1002: substr( pay_gb_eoy_archive.get_parameter(

998: CURSOR c_param_values IS
999: SELECT to_number( pay_gb_eoy_archive.get_parameter(
1000: legislative_parameters,
1001: 'PAYROLL_ID')) payroll_id,
1002: substr( pay_gb_eoy_archive.get_parameter(
1003: legislative_parameters,
1004: 'TAX_REF'),1,20) tax_ref,
1005: start_date,
1006: effective_date,

Line 1008: pay_gb_eoy_archive.get_parameter(

1004: 'TAX_REF'),1,20) tax_ref,
1005: start_date,
1006: effective_date,
1007: fnd_date.canonical_to_date(
1008: pay_gb_eoy_archive.get_parameter(
1009: legislative_parameters,
1010: 'END_DATE')) end_date,
1011: business_group_id
1012: FROM pay_payroll_actions