eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_CBS_FILE dependencies on PAY_CORE_UTILS

Line 40: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTING_DATE',legislative_parameters))

36: ,p_density OUT NOCOPY NUMBER
37: ) IS
38: --
39: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
40: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTING_DATE',legislative_parameters))
41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)
43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)

Line 41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)

37: ) IS
38: --
39: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
40: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTING_DATE',legislative_parameters))
41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)
43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)
45: ,pay_core_utils.get_parameter('DENSITY',legislative_parameters)

Line 42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)

38: --
39: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
40: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTING_DATE',legislative_parameters))
41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)
43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)
45: ,pay_core_utils.get_parameter('DENSITY',legislative_parameters)
46: ,effective_date

Line 43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)

39: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
40: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTING_DATE',legislative_parameters))
41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)
43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)
45: ,pay_core_utils.get_parameter('DENSITY',legislative_parameters)
46: ,effective_date
47: ,business_group_id

Line 44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)

40: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTING_DATE',legislative_parameters))
41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)
43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)
45: ,pay_core_utils.get_parameter('DENSITY',legislative_parameters)
46: ,effective_date
47: ,business_group_id
48: FROM pay_payroll_actions

Line 45: ,pay_core_utils.get_parameter('DENSITY',legislative_parameters)

41: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
42: ,pay_core_utils.get_parameter('ORG_STRUCT_ID',legislative_parameters)
43: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)
45: ,pay_core_utils.get_parameter('DENSITY',legislative_parameters)
46: ,effective_date
47: ,business_group_id
48: FROM pay_payroll_actions
49: WHERE payroll_action_id = p_payroll_action_id;