DBA Data[Home] [Help]

APPS.PAY_KR_NPA_PKG dependencies on PAY_CORE_UTILS

Line 65: pay_core_utils.get_parameter('BP_NP_NUMBER',ppa.legislative_parameters) -- Bug 3506172

61: ppa.report_qualifier,
62: ppa.report_category,
63: ppa.business_group_id,
64: ppa.effective_date,
65: pay_core_utils.get_parameter('BP_NP_NUMBER',ppa.legislative_parameters) -- Bug 3506172
66: INTO g_pact
67: FROM pay_payroll_actions ppa
68: WHERE ppa.payroll_action_id = p_payroll_action_id;
69:

Line 95: SELECT to_date('01-11-'||to_char(to_number(to_char(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters)),'YYYY'))-1),'DD-MM-YYYY')

91: l_locking_action_id NUMBER;
92: l_start_date DATE;
93: l_end_date DATE;
94: CURSOR csr_date IS
95: SELECT to_date('01-11-'||to_char(to_number(to_char(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters)),'YYYY'))-1),'DD-MM-YYYY')
96: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters))
97: FROM pay_payroll_actions bppa
98: WHERE bppa.payroll_action_id = p_payroll_action_id;
99:

Line 96: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters))

92: l_start_date DATE;
93: l_end_date DATE;
94: CURSOR csr_date IS
95: SELECT to_date('01-11-'||to_char(to_number(to_char(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters)),'YYYY'))-1),'DD-MM-YYYY')
96: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters))
97: FROM pay_payroll_actions bppa
98: WHERE bppa.payroll_action_id = p_payroll_action_id;
99:
100: ------------------------------------------------------------------------------