APPS.PAY_NO_PACCR_PKG dependencies on FND_DATE

Line 84: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_START_DATE'))

80: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ELEMENT_NAME')
81: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'EOY_CODE')
82: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'COSTING_SEG')
83: ,effective_date
84: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_START_DATE'))
85: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
86: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
87: ,business_group_id
88: FROM pay_payroll_actions

Line 85: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))

81: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'EOY_CODE')
82: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'COSTING_SEG')
83: ,effective_date
84: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_START_DATE'))
85: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
86: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
87: ,business_group_id
88: FROM pay_payroll_actions
89: WHERE payroll_action_id = p_payroll_action_id;

Line 248: OPEN csr_get_le_details(l_le_id ,fnd_date.canonical_to_date(l_to_date),l_business_group_id);

244: l_from_date := to_char(l_report_start_date,'YYYYMMDD');
245:
246:
247: /* To fetch Legal Employer Details */
248: OPEN csr_get_le_details(l_le_id ,fnd_date.canonical_to_date(l_to_date),l_business_group_id);
249: FETCH csr_get_le_details INTO rec_le_details;
250: CLOSE csr_get_le_details;
251:
252: l_le_name := rec_le_details.name;

Line 339: ,fnd_date.CANONICAL_TO_DATE(action_information5) from_date

335: IS
336: /* Cursor to fetch useful header information to transfer to body records from already archived header information */
337: CURSOR csr_get_hdr_info(p_payroll_action_id NUMBER) IS
338: SELECT effective_date
339: ,fnd_date.CANONICAL_TO_DATE(action_information5) from_date
340: ,fnd_date.CANONICAL_TO_DATE(action_information6) to_date
341: ,to_number(action_information2) business_group_id
342: ,to_number(action_information3) payroll_id
343: ,action_information10 eoy_code

Line 340: ,fnd_date.CANONICAL_TO_DATE(action_information6) to_date

336: /* Cursor to fetch useful header information to transfer to body records from already archived header information */
337: CURSOR csr_get_hdr_info(p_payroll_action_id NUMBER) IS
338: SELECT effective_date
339: ,fnd_date.CANONICAL_TO_DATE(action_information5) from_date
340: ,fnd_date.CANONICAL_TO_DATE(action_information6) to_date
341: ,to_number(action_information2) business_group_id
342: ,to_number(action_information3) payroll_id
343: ,action_information10 eoy_code
344: ,tax_unit_id

Line 1348: ,fnd_date.date_to_canonical(action_information16)

1344: ,action_information8
1345: ,action_information15
1346: ,action_information12
1347: ,action_information5
1348: ,fnd_date.date_to_canonical(action_information16)
1349: ,fnd_number.canonical_to_number(action_information14)
1350: ,effective_date;
1351:
1352: