APPS.PAY_DK_ABSR_PKG dependencies on FND_DATE

Line 99: ,fnd_date.canonical_to_date(PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))

95: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
96: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'YEAR')
97: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date
99: ,fnd_date.canonical_to_date(PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
100: ,business_group_id
101: FROM pay_payroll_actions
102: WHERE payroll_action_id = p_payroll_action_id;
103:

Line 353: OPEN csr_get_sender_details(l_sender_id,fnd_date.canonical_to_date(l_to_date),l_business_group_id);

349:
350: /* To obtain Sender's details */
351: /* The Sender would be Service Provider if present in the system or else it would be the Legal Employer Specified */
352: /*
353: OPEN csr_get_sender_details(l_sender_id,fnd_date.canonical_to_date(l_to_date),l_business_group_id);
354: FETCH csr_get_sender_details INTO rec_sender_details;
355: CLOSE csr_get_sender_details;
356:
357: l_sender_cvr_no := rec_sender_details.cvr_no;

Line 364: OPEN csr_get_bg_details(l_business_group_id,fnd_date.canonical_to_date(l_to_date));

360: l_sender_pcode := rec_sender_details.pcode;
361: */
362: /* To obtain Business Group details */
363:
364: OPEN csr_get_bg_details(l_business_group_id,fnd_date.canonical_to_date(l_to_date));
365: FETCH csr_get_bg_details INTO rec_bg_details;
366: CLOSE csr_get_bg_details;
367:
368: l_bg_da_sys_no := rec_bg_details.da_sys_no;

Line 375: FOR rec_le_details IN csr_get_le_details(l_sender_id,l_sender_cvr_no,fnd_date.canonical_to_date(l_to_date),l_business_group_id)

371: THEN
372: RAISE e_no_da_sys_no;
373: END IF;
374:
375: FOR rec_le_details IN csr_get_le_details(l_sender_id,l_sender_cvr_no,fnd_date.canonical_to_date(l_to_date),l_business_group_id)
376: LOOP
377: /* To obtain Legal Employer's details from details provided in File Header*/
378:
379:

Line 389: OPEN csr_get_le_da_off_codes(l_le_id,fnd_date.canonical_to_date(l_to_date),l_business_group_id);

385: l_le_id := rec_le_details.org_id;
386: l_le_punit := rec_le_details.punit;
387:
388:
389: OPEN csr_get_le_da_off_codes(l_le_id,fnd_date.canonical_to_date(l_to_date),l_business_group_id);
390: FETCH csr_get_le_da_off_codes INTO rec_get_le_da_off_codes;
391: CLOSE csr_get_le_da_off_codes;
392:
393: l_le_da_scode := rec_get_le_da_off_codes.da_scode;

Line 452: ,fnd_date.CANONICAL_TO_DATE(action_information6) from_date

448:
449: /* Cursor to fetch useful header information to transfer to body records from already archived header information */
450: CURSOR csr_get_hdr_info(p_payroll_action_id NUMBER) IS
451: SELECT effective_date
452: ,fnd_date.CANONICAL_TO_DATE(action_information6) from_date
453: ,fnd_date.CANONICAL_TO_DATE(action_information7) to_date
454: ,to_number(action_information2) business_group_id
455: ,tax_unit_id
456: ,to_number(action_information3) PAYROLL_ID

Line 453: ,fnd_date.CANONICAL_TO_DATE(action_information7) to_date

449: /* Cursor to fetch useful header information to transfer to body records from already archived header information */
450: CURSOR csr_get_hdr_info(p_payroll_action_id NUMBER) IS
451: SELECT effective_date
452: ,fnd_date.CANONICAL_TO_DATE(action_information6) from_date
453: ,fnd_date.CANONICAL_TO_DATE(action_information7) to_date
454: ,to_number(action_information2) business_group_id
455: ,tax_unit_id
456: ,to_number(action_information3) PAYROLL_ID
457: ,action_information8 LE_NAME