APPS.PAY_DK_STATSR_PKG dependencies on FND_DATE

Line 100: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))

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

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

456:
457: /* To obtain Sender's details */
458: /* The Sender would be Service Provider if present in the system or else it would be the Legal Employer Specified */
459:
460: OPEN csr_get_sender_details(l_sender_id,fnd_date.canonical_to_date(l_to_date),l_business_group_id);
461: FETCH csr_get_sender_details INTO rec_sender_details;
462: CLOSE csr_get_sender_details;
463:
464: l_sender_cvr_no := rec_sender_details.cvr_no;

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

467: l_sender_pcode := rec_sender_details.pcode;
468:
469: /* To obtain Business Group details */
470:
471: OPEN csr_get_bg_details(l_business_group_id,fnd_date.canonical_to_date(l_to_date));
472: FETCH csr_get_bg_details INTO rec_bg_details;
473: CLOSE csr_get_bg_details;
474:
475: l_bg_da_sys_no := rec_bg_details.da_sys_no;

Line 512: 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)

508: ,p_action_information15 => l_sys_name -- Payroll System Name
509: );
510:
511:
512: 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)
513: LOOP
514: /* To obtain Legal Employer's details from details provided in File Header*/
515:
516:

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

521: l_le_pcode := rec_le_details.pcode;
522: l_le_id := rec_le_details.org_id;
523:
524:
525: OPEN csr_get_le_da_off_codes(l_le_id,fnd_date.canonical_to_date(l_to_date),l_business_group_id);
526: FETCH csr_get_le_da_off_codes INTO rec_get_le_da_off_codes;
527: CLOSE csr_get_le_da_off_codes;
528:
529: l_le_da_scode := rec_get_le_da_off_codes.da_scode;

Line 584: ,fnd_date.CANONICAL_TO_DATE(action_information6) from_date

580:
581: /* Cursor to fetch useful header information to transfer to body records from already archived header information */
582: CURSOR csr_get_hdr_info(p_payroll_action_id NUMBER) IS
583: SELECT effective_date
584: ,fnd_date.CANONICAL_TO_DATE(action_information6) from_date
585: ,fnd_date.CANONICAL_TO_DATE(action_information7) to_date
586: ,to_number(action_information2) business_group_id
587: FROM pay_action_information pai
588: WHERE action_context_type = 'PA'

Line 585: ,fnd_date.CANONICAL_TO_DATE(action_information7) to_date

581: /* Cursor to fetch useful header information to transfer to body records from already archived header information */
582: CURSOR csr_get_hdr_info(p_payroll_action_id NUMBER) IS
583: SELECT effective_date
584: ,fnd_date.CANONICAL_TO_DATE(action_information6) from_date
585: ,fnd_date.CANONICAL_TO_DATE(action_information7) to_date
586: ,to_number(action_information2) business_group_id
587: FROM pay_action_information pai
588: WHERE action_context_type = 'PA'
589: AND action_context_id = p_payroll_action_id