APPS.PAY_SE_EMPLOYMENT_STATISTICS dependencies on FND_DATE

Line 188: fnd_date.canonical_to_date (lr_parameter_info.ACCOUNT_DATE);

184: p_local_unit_id := lr_parameter_info.LOCAL_UNIT_ID;
185:
186:
187: p_ACCOUNT_DATE :=
188: fnd_date.canonical_to_date (lr_parameter_info.ACCOUNT_DATE);
189:
190:
191: P_POSTING_DATE :=
192: fnd_date.canonical_to_date (lr_parameter_info.POSTING_DATE);

Line 192: fnd_date.canonical_to_date (lr_parameter_info.POSTING_DATE);

188: fnd_date.canonical_to_date (lr_parameter_info.ACCOUNT_DATE);
189:
190:
191: P_POSTING_DATE :=
192: fnd_date.canonical_to_date (lr_parameter_info.POSTING_DATE);
193: P_REPORTING_DATE :=
194: fnd_date.canonical_to_date (lr_parameter_info.REPORTING_DATE);
195: p_effective_date := lr_parameter_info.effective_date;
196: p_business_group_id := lr_parameter_info.bg_id;

Line 194: fnd_date.canonical_to_date (lr_parameter_info.REPORTING_DATE);

190:
191: P_POSTING_DATE :=
192: fnd_date.canonical_to_date (lr_parameter_info.POSTING_DATE);
193: P_REPORTING_DATE :=
194: fnd_date.canonical_to_date (lr_parameter_info.REPORTING_DATE);
195: p_effective_date := lr_parameter_info.effective_date;
196: p_business_group_id := lr_parameter_info.bg_id;
197:
198:

Line 621: , p_action_information8 => fnd_date.date_to_canonical

617: , p_action_information4 => L_LEGAL_EMPLOYER_NAME
618: , p_action_information5 => hr_general.decode_lookup('SE_REQUEST_LEVEL',g_LU_request)
619: , p_action_information6 => g_local_unit_id
620: , p_action_information7 => L_LOCAL_UNIT_NAME
621: , p_action_information8 => fnd_date.date_to_canonical
622: (g_account_date)
623: , p_action_information9 => fnd_date.date_to_canonical
624: (g_posting_date)
625: , p_action_information10 => fnd_date.date_to_canonical(g_reporting_date)

Line 623: , p_action_information9 => fnd_date.date_to_canonical

619: , p_action_information6 => g_local_unit_id
620: , p_action_information7 => L_LOCAL_UNIT_NAME
621: , p_action_information8 => fnd_date.date_to_canonical
622: (g_account_date)
623: , p_action_information9 => fnd_date.date_to_canonical
624: (g_posting_date)
625: , p_action_information10 => fnd_date.date_to_canonical(g_reporting_date)
626: );
627: -- *****************************************************************************

Line 625: , p_action_information10 => fnd_date.date_to_canonical(g_reporting_date)

621: , p_action_information8 => fnd_date.date_to_canonical
622: (g_account_date)
623: , p_action_information9 => fnd_date.date_to_canonical
624: (g_posting_date)
625: , p_action_information10 => fnd_date.date_to_canonical(g_reporting_date)
626: );
627: -- *****************************************************************************
628:
629:

Line 1522: , p_action_information5 => fnd_date.date_to_canonical

1518: , p_action_information1 => 'PYSEHPDA'
1519: , p_action_information2 => l_legal_employer_details.legal_employer_name
1520: , p_action_information3 => g_legal_employer_id
1521: , p_action_information4 => g_LE_request
1522: , p_action_information5 => fnd_date.date_to_canonical
1523: (g_posting_date)
1524: , p_action_information6 => fnd_date.date_to_canonical
1525: (g_account_date)
1526: , p_action_information7 => NULL

Line 1524: , p_action_information6 => fnd_date.date_to_canonical

1520: , p_action_information3 => g_legal_employer_id
1521: , p_action_information4 => g_LE_request
1522: , p_action_information5 => fnd_date.date_to_canonical
1523: (g_posting_date)
1524: , p_action_information6 => fnd_date.date_to_canonical
1525: (g_account_date)
1526: , p_action_information7 => NULL
1527: , p_action_information8 => NULL
1528: , p_action_information9 => NULL

Line 2018: (fnd_date.canonical_to_date (action_information5)

2014: csr_v_pa_id pay_action_information.action_context_id%TYPE
2015: )
2016: IS
2017: SELECT TO_CHAR
2018: (fnd_date.canonical_to_date (action_information5)
2019: , 'YYYYMMDD'
2020: ) period_from
2021: , TO_CHAR
2022: (fnd_date.canonical_to_date (action_information6)

Line 2022: (fnd_date.canonical_to_date (action_information6)

2018: (fnd_date.canonical_to_date (action_information5)
2019: , 'YYYYMMDD'
2020: ) period_from
2021: , TO_CHAR
2022: (fnd_date.canonical_to_date (action_information6)
2023: , 'YYYYMMDD'
2024: ) period_to
2025: FROM pay_action_information
2026: WHERE action_context_type = 'PA'