eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on FND_DATE

Line 102: , to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'PAYMENT_DD',null)),'DDMMYY')

98:
99: /* Added context for PAYROLL_ACTION_ID for enh 6344939 */
100: CURSOR get_section_record_details IS
101: SELECT 'TRANSFER_DISPOSAL_DATE=P'
102: , to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'PAYMENT_DD',null)),'DDMMYY')
103: , 'TRANSFER_PAYER_CVR_NO=P'
104: , hoi2.org_information1
105: , 'TRANSFER_LE_ID=P'
106: , to_char(hou.ORGANIZATION_ID)

Line 168: , to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'INFOTYPE'||puci.value||'_DD',null)),'DDMMYY')

164: CURSOR get_info_record_details IS
165: SELECT 'TRANSFER_INFO_TYPE=P'
166: , puci.value
167: , 'TRANSFER_INFO_DISPOSAL_DATE=P'
168: , to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'INFOTYPE'||puci.value||'_DD',null)),'DDMMYY')
169: , 'TRANSFER_PBS_NO=P'
170: , puci1.value
171: , 'TRANSFER_RECEIVER_NAME=P'
172: , pur.row_low_range_or_name

Line 203: , to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'INFOTYPE_PENSION_DD',null)),'DDMMYY')

199: UNION
200: SELECT 'TRANSFER_INFO_TYPE=P'
201: , hoi2.ORG_INFORMATION2
202: , 'TRANSFER_INFO_DISPOSAL_DATE=P'
203: , to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'INFOTYPE_PENSION_DD',null)),'DDMMYY')
204: , 'TRANSFER_PBS_NO=P'
205: , hoi2.ORG_INFORMATION1
206: , 'TRANSFER_RECEIVER_NAME=P'
207: , hou.name

Line 242: /, to_char(fnd_date.canonical_to_date(nvl(scl.segment8,pap.effective_end_date)),'YYYYMMDD')/

238: , 'TRANSFER_ASSIGNMENT_ID=P'
239: , paa.ASSIGNMENT_ID
240: , 'TRANSFER_TERMINATION_DATE=P'
241: /* Re-written to obtain correct dates*/
242: /*, to_char(fnd_date.canonical_to_date(nvl(scl.segment8,pap.effective_end_date)),'YYYYMMDD')*/
243: , to_char(decode(scl.segment8,null,pap.effective_end_date,fnd_date.canonical_to_date(scl.segment8)),'YYYYMMDD')
244: , 'TRANSFER_PERSON_ID=P'
245: , to_char(pap.person_id)
246: , 'TRANSFER_EMPLOYMENT_CATEGORY=P'

Line 243: , to_char(decode(scl.segment8,null,pap.effective_end_date,fnd_date.canonical_to_date(scl.segment8)),'YYYYMMDD')

239: , paa.ASSIGNMENT_ID
240: , 'TRANSFER_TERMINATION_DATE=P'
241: /* Re-written to obtain correct dates*/
242: /*, to_char(fnd_date.canonical_to_date(nvl(scl.segment8,pap.effective_end_date)),'YYYYMMDD')*/
243: , to_char(decode(scl.segment8,null,pap.effective_end_date,fnd_date.canonical_to_date(scl.segment8)),'YYYYMMDD')
244: , 'TRANSFER_PERSON_ID=P'
245: , to_char(pap.person_id)
246: , 'TRANSFER_EMPLOYMENT_CATEGORY=P'
247: , paf.employment_category

Line 265: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))

261: /* Added for bug fix 5533140 */
262: , 'ASSIGNMENT_ID=C'
263: , paa.ASSIGNMENT_ID
264: , 'DATE_EARNED=C'
265: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
266: FROM per_all_assignments_f paf
267: , per_all_people_f pap
268: , hr_soft_coding_keyflex scl
269: , pay_payroll_actions ppa

Line 340: /, to_char(fnd_date.canonical_to_date(nvl(scl.segment8,pap.effective_end_date)),'YYYYMMDD')/

336: , 'TRANSFER_ASSIGNMENT_ID=P'
337: , paa.ASSIGNMENT_ID
338: , 'TRANSFER_TERMINATION_DATE=P'
339: /* Re-written to obtain correct dates*/
340: /*, to_char(fnd_date.canonical_to_date(nvl(scl.segment8,pap.effective_end_date)),'YYYYMMDD')*/
341: , to_char(decode(scl.segment8,null,pap.effective_end_date,fnd_date.canonical_to_date(scl.segment8)),'YYYYMMDD')
342: , 'TRANSFER_PERSON_ID=P'
343: , to_char(pap.person_id)
344: , 'TRANSFER_EMPLOYMENT_CATEGORY=P'

Line 341: , to_char(decode(scl.segment8,null,pap.effective_end_date,fnd_date.canonical_to_date(scl.segment8)),'YYYYMMDD')

337: , paa.ASSIGNMENT_ID
338: , 'TRANSFER_TERMINATION_DATE=P'
339: /* Re-written to obtain correct dates*/
340: /*, to_char(fnd_date.canonical_to_date(nvl(scl.segment8,pap.effective_end_date)),'YYYYMMDD')*/
341: , to_char(decode(scl.segment8,null,pap.effective_end_date,fnd_date.canonical_to_date(scl.segment8)),'YYYYMMDD')
342: , 'TRANSFER_PERSON_ID=P'
343: , to_char(pap.person_id)
344: , 'TRANSFER_EMPLOYMENT_CATEGORY=P'
345: , paf.employment_category

Line 363: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))

359: /* Added for bug fix 5533140 */
360: , 'ASSIGNMENT_ID=C'
361: , paa.ASSIGNMENT_ID
362: , 'DATE_EARNED=C'
363: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
364: FROM per_all_assignments_f paf
365: , per_all_people_f pap
366: , hr_soft_coding_keyflex scl
367: , pay_payroll_actions ppa

Line 418: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))

414: , to_char(pee1.effective_start_date ,'YYYYMMDD')
415: , 'ASSIGNMENT_ID=C'
416: , paa.ASSIGNMENT_ID
417: , 'DATE_EARNED=C'
418: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
419: , 'PAYROLL_ACTION_ID=C'
420: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
421: , 'FULL_NAME=P'
422: , hou.name /*bug fix 4551283*/

Line 473: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))

469: , to_char(pee1.effective_start_date ,'YYYYMMDD')
470: , 'ASSIGNMENT_ID=C'
471: , paa.ASSIGNMENT_ID
472: , 'DATE_EARNED=C'
473: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
474: , 'ASSIGNMENT_ACTION_ID=C'
475: , PAY_DK_PAYMENT_PROCESS_PKG.get_ass_action_context(paa.ASSIGNMENT_ID)
476: , 'PAYROLL_ACTION_ID=C'
477: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 531: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))

527: , PAY_DK_PAYMENT_PROCESS_PKG.get_ass_action_context(paa.ASSIGNMENT_ID)
528: , 'ASSIGNMENT_ID=C'
529: , paa.ASSIGNMENT_ID
530: ,'DATE_EARNED=C'
531: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
532: , 'PAYROLL_ACTION_ID=C'
533: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
534: FROM pay_payroll_actions ppa
535: , pay_assignment_actions paa