APPS.PAY_DK_STATSR_PKG dependencies on FND_DATE

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

95: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
96: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date
99: ,fnd_date.canonical_to_date(PAY_DK_STATSR_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 475: OPEN csr_get_sender_details(l_sender_id,fnd_date.canonical_to_date(l_to_date),l_business_group_id);

471:
472: /* To obtain Sender's details */
473: /* The Sender would be Service Provider if present in the system or else it would be the Legal Employer Specified */
474:
475: OPEN csr_get_sender_details(l_sender_id,fnd_date.canonical_to_date(l_to_date),l_business_group_id);
476: FETCH csr_get_sender_details INTO rec_sender_details;
477: CLOSE csr_get_sender_details;
478:
479: l_sender_cvr_no := rec_sender_details.cvr_no;

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

482: l_sender_pcode := rec_sender_details.pcode;
483:
484: /* To obtain Business Group details */
485:
486: OPEN csr_get_bg_details(l_business_group_id,fnd_date.canonical_to_date(l_to_date));
487: FETCH csr_get_bg_details INTO rec_bg_details;
488: CLOSE csr_get_bg_details;
489:
490: l_bg_da_sys_no := rec_bg_details.da_sys_no;

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

533: ,p_action_information15 => l_sys_name -- Payroll System Name
534: );
535:
536:
537: 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)
538: LOOP
539: /* To obtain Legal Employer's details from details provided in File Header*/
540:
541:

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

547: l_le_id := rec_le_details.org_id;
548: l_le_punit := rec_le_details.punit;
549:
550:
551: OPEN csr_get_le_da_off_codes(l_le_id,fnd_date.canonical_to_date(l_to_date),l_business_group_id);
552: FETCH csr_get_le_da_off_codes INTO rec_get_le_da_off_codes;
553: CLOSE csr_get_le_da_off_codes;
554:
555: l_le_da_scode := rec_get_le_da_off_codes.da_scode;

Line 611: ,fnd_date.CANONICAL_TO_DATE(action_information6) from_date

607:
608: /* Cursor to fetch useful header information to transfer to body records from already archived header information */
609: CURSOR csr_get_hdr_info(p_payroll_action_id NUMBER) IS
610: SELECT effective_date
611: ,fnd_date.CANONICAL_TO_DATE(action_information6) from_date
612: ,fnd_date.CANONICAL_TO_DATE(action_information7) to_date
613: ,to_number(action_information2) business_group_id
614: FROM pay_action_information pai
615: WHERE action_context_type = 'PA'

Line 612: ,fnd_date.CANONICAL_TO_DATE(action_information7) to_date

608: /* Cursor to fetch useful header information to transfer to body records from already archived header information */
609: CURSOR csr_get_hdr_info(p_payroll_action_id NUMBER) IS
610: SELECT effective_date
611: ,fnd_date.CANONICAL_TO_DATE(action_information6) from_date
612: ,fnd_date.CANONICAL_TO_DATE(action_information7) to_date
613: ,to_number(action_information2) business_group_id
614: FROM pay_action_information pai
615: WHERE action_context_type = 'PA'
616: AND action_context_id = p_payroll_action_id

Line 1143: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE')) --8848543

1139: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
1140: END IF;
1141:
1142: SELECT PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
1143: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE')) --8848543
1144: INTO l_span, l_pd_date_to --8848543
1145: FROM pay_payroll_actions
1146: WHERE payroll_action_id = p_payroll_action_id;
1147: --8848543