APPS.PAY_SE_TRNR dependencies on FND_DATE

Line 10: SELECT fnd_date.canonical_to_date (action_information5) joinig_start_date,

6: p_template_name IN VARCHAR2,
7: p_xml OUT NOCOPY CLOB
8: ) IS
9: CURSOR csr_report_parameters IS
10: SELECT fnd_date.canonical_to_date (action_information5) joinig_start_date,
11: fnd_date.canonical_to_date (action_information6)
12: joinig_end_date, action_information9 division,
13: action_information12 agreement_area, action_information13 empployee_category,
14: action_information14

Line 11: fnd_date.canonical_to_date (action_information6)

7: p_xml OUT NOCOPY CLOB
8: ) IS
9: CURSOR csr_report_parameters IS
10: SELECT fnd_date.canonical_to_date (action_information5) joinig_start_date,
11: fnd_date.canonical_to_date (action_information6)
12: joinig_end_date, action_information9 division,
13: action_information12 agreement_area, action_information13 empployee_category,
14: action_information14
15: assignment_category,

Line 16: fnd_date.canonical_to_date (action_information16) start_date_of_birth,

12: joinig_end_date, action_information9 division,
13: action_information12 agreement_area, action_information13 empployee_category,
14: action_information14
15: assignment_category,
16: fnd_date.canonical_to_date (action_information16) start_date_of_birth,
17: fnd_date.canonical_to_date (action_information17)
18: end_date_of_birth,
19: fnd_date.canonical_to_date (action_information18) precedence_end_date,
20: fnd_date.canonical_to_date (action_information19)

Line 17: fnd_date.canonical_to_date (action_information17)

13: action_information12 agreement_area, action_information13 empployee_category,
14: action_information14
15: assignment_category,
16: fnd_date.canonical_to_date (action_information16) start_date_of_birth,
17: fnd_date.canonical_to_date (action_information17)
18: end_date_of_birth,
19: fnd_date.canonical_to_date (action_information18) precedence_end_date,
20: fnd_date.canonical_to_date (action_information19)
21: report_date, action_information20 sort_order

Line 19: fnd_date.canonical_to_date (action_information18) precedence_end_date,

15: assignment_category,
16: fnd_date.canonical_to_date (action_information16) start_date_of_birth,
17: fnd_date.canonical_to_date (action_information17)
18: end_date_of_birth,
19: fnd_date.canonical_to_date (action_information18) precedence_end_date,
20: fnd_date.canonical_to_date (action_information19)
21: report_date, action_information20 sort_order
22: FROM pay_action_information
23: WHERE action_context_id = p_payroll_action_id AND action_information_category = 'EMEA REPORT DETAILS';

Line 20: fnd_date.canonical_to_date (action_information19)

16: fnd_date.canonical_to_date (action_information16) start_date_of_birth,
17: fnd_date.canonical_to_date (action_information17)
18: end_date_of_birth,
19: fnd_date.canonical_to_date (action_information18) precedence_end_date,
20: fnd_date.canonical_to_date (action_information19)
21: report_date, action_information20 sort_order
22: FROM pay_action_information
23: WHERE action_context_id = p_payroll_action_id AND action_information_category = 'EMEA REPORT DETAILS';
24:

Line 203: fnd_date.canonical_to_date (action_information7)

199: l_select_str :=
200: 'SELECT action_information4 national_identifier,
201: action_information5
202: assignment_number, action_information6 full_name,
203: fnd_date.canonical_to_date (action_information7)
204: hire_date,
205: fnd_number.canonical_to_number (action_information8) total_emp_time,
206: fnd_date.canonical_to_date (action_information9)
207: precedence_date,

Line 206: fnd_date.canonical_to_date (action_information9)

202: assignment_number, action_information6 full_name,
203: fnd_date.canonical_to_date (action_information7)
204: hire_date,
205: fnd_number.canonical_to_number (action_information8) total_emp_time,
206: fnd_date.canonical_to_date (action_information9)
207: precedence_date,
208: fnd_date.canonical_to_date (action_information10) termination_date, action_information11 emp_type,
209: action_information12
210: emp_sec

Line 208: fnd_date.canonical_to_date (action_information10) termination_date, action_information11 emp_type,

204: hire_date,
205: fnd_number.canonical_to_number (action_information8) total_emp_time,
206: fnd_date.canonical_to_date (action_information9)
207: precedence_date,
208: fnd_date.canonical_to_date (action_information10) termination_date, action_information11 emp_type,
209: action_information12
210: emp_sec
211: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
212: WHERE paa.payroll_action_id = '