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 218: , to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'PAYMENT_DD',null)),'DDMMYY')

214:
215: /* Added context for PAYROLL_ACTION_ID for enh 6344939 */
216: CURSOR get_section_record_details IS
217: SELECT 'TRANSFER_DISPOSAL_DATE=P'
218: , to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'PAYMENT_DD',null)),'DDMMYY')
219: , 'TRANSFER_PAYER_CVR_NO=P'
220: , hoi2.org_information1
221: , 'TRANSFER_LE_ID=P'
222: , to_char(hou.ORGANIZATION_ID)

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

284:
285: --9036229
286: CURSOR get_section_rp_details IS
287: SELECT 'TRANSFER_DISPOSAL_DATE=P'
288: --, to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'PAYMENT_DD',null)),'DDMMYY')
289: , to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'INFOTYPE_RATE_DD',null)),'DDMMYY') --10221019
290: , 'TRANSFER_PAYER_CVR_NO=P'
291: , hoi2.org_information1
292: , 'TRANSFER_LE_ID=P'

Line 289: , to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'INFOTYPE_RATE_DD',null)),'DDMMYY') --10221019

285: --9036229
286: CURSOR get_section_rp_details IS
287: SELECT 'TRANSFER_DISPOSAL_DATE=P'
288: --, to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'PAYMENT_DD',null)),'DDMMYY')
289: , to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'INFOTYPE_RATE_DD',null)),'DDMMYY') --10221019
290: , 'TRANSFER_PAYER_CVR_NO=P'
291: , hoi2.org_information1
292: , 'TRANSFER_LE_ID=P'
293: , to_char(hou.ORGANIZATION_ID)

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

369: CURSOR get_info_record_details IS
370: SELECT 'TRANSFER_INFO_TYPE=P'
371: , puci.value
372: , 'TRANSFER_INFO_DISPOSAL_DATE=P'
373: , to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'INFOTYPE'||puci.value||'_DD',null)),'DDMMYY')
374: , 'TRANSFER_PBS_NO=P'
375: , puci1.value
376: , 'TRANSFER_RECEIVER_NAME=P'
377: , pur.row_low_range_or_name

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

404: UNION
405: SELECT 'TRANSFER_INFO_TYPE=P'
406: , hoi2.ORG_INFORMATION2
407: , 'TRANSFER_INFO_DISPOSAL_DATE=P'
408: , to_char(fnd_date.canonical_to_date(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'INFOTYPE_PENSION_DD',null)),'DDMMYY')
409: , 'TRANSFER_PBS_NO=P'
410: , hoi2.ORG_INFORMATION1
411: , 'TRANSFER_RECEIVER_NAME=P'
412: , hou.name

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

443: , 'TRANSFER_ASSIGNMENT_ID=P'
444: , paa.ASSIGNMENT_ID
445: , 'TRANSFER_TERMINATION_DATE=P'
446: /* Re-written to obtain correct dates*/
447: /*, to_char(fnd_date.canonical_to_date(nvl(scl.segment8,pap.effective_end_date)),'YYYYMMDD')*/
448: , to_char(decode(scl.segment8,null,pap.effective_end_date,fnd_date.canonical_to_date(scl.segment8)),'YYYYMMDD')
449: , 'TRANSFER_PERSON_ID=P'
450: , to_char(pap.person_id)
451: , 'TRANSFER_EMPLOYMENT_CATEGORY=P'

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

444: , paa.ASSIGNMENT_ID
445: , 'TRANSFER_TERMINATION_DATE=P'
446: /* Re-written to obtain correct dates*/
447: /*, to_char(fnd_date.canonical_to_date(nvl(scl.segment8,pap.effective_end_date)),'YYYYMMDD')*/
448: , to_char(decode(scl.segment8,null,pap.effective_end_date,fnd_date.canonical_to_date(scl.segment8)),'YYYYMMDD')
449: , 'TRANSFER_PERSON_ID=P'
450: , to_char(pap.person_id)
451: , 'TRANSFER_EMPLOYMENT_CATEGORY=P'
452: , paf.employment_category

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

466: /* Added for bug fix 5533140 */
467: , 'ASSIGNMENT_ID=C'
468: , paa.ASSIGNMENT_ID
469: , 'DATE_EARNED=C'
470: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
471: FROM per_all_assignments_f paf
472: , per_all_people_f pap
473: , hr_soft_coding_keyflex scl
474: , pay_payroll_actions ppa

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

568: , 'TRANSFER_ASSIGNMENT_ID=P'
569: , paa.ASSIGNMENT_ID
570: , 'TRANSFER_TERMINATION_DATE=P'
571: /* Re-written to obtain correct dates*/
572: /*, to_char(fnd_date.canonical_to_date(nvl(scl.segment8,pap.effective_end_date)),'YYYYMMDD')*/
573: , to_char(decode(scl.segment8,null,pap.effective_end_date,fnd_date.canonical_to_date(scl.segment8)),'YYYYMMDD')
574: , 'TRANSFER_PERSON_ID=P'
575: , to_char(pap.person_id)
576: , 'TRANSFER_EMPLOYMENT_CATEGORY=P'

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

569: , paa.ASSIGNMENT_ID
570: , 'TRANSFER_TERMINATION_DATE=P'
571: /* Re-written to obtain correct dates*/
572: /*, to_char(fnd_date.canonical_to_date(nvl(scl.segment8,pap.effective_end_date)),'YYYYMMDD')*/
573: , to_char(decode(scl.segment8,null,pap.effective_end_date,fnd_date.canonical_to_date(scl.segment8)),'YYYYMMDD')
574: , 'TRANSFER_PERSON_ID=P'
575: , to_char(pap.person_id)
576: , 'TRANSFER_EMPLOYMENT_CATEGORY=P'
577: , paf.employment_category

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

591: /* Added for bug fix 5533140 */
592: , 'ASSIGNMENT_ID=C'
593: , paa.ASSIGNMENT_ID
594: , 'DATE_EARNED=C'
595: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
596: FROM per_all_assignments_f paf
597: , per_all_people_f pap
598: , hr_soft_coding_keyflex scl
599: , pay_payroll_actions ppa

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

646: , to_char(pee1.effective_start_date ,'YYYYMMDD')
647: , 'ASSIGNMENT_ID=C'
648: , paa.ASSIGNMENT_ID
649: , 'DATE_EARNED=C'
650: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
651: , 'PAYROLL_ACTION_ID=C'
652: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
653: , 'FULL_NAME=P'
654: , hou.name /*bug fix 4551283*/

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

701: , to_char(pee1.effective_start_date ,'YYYYMMDD')
702: , 'ASSIGNMENT_ID=C'
703: , paa.ASSIGNMENT_ID
704: , 'DATE_EARNED=C'
705: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
706: , 'ASSIGNMENT_ACTION_ID=C'
707: , PAY_DK_PAYMENT_PROCESS_PKG.get_ass_action_context(paa.ASSIGNMENT_ID)
708: , 'PAYROLL_ACTION_ID=C'
709: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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

759: , PAY_DK_PAYMENT_PROCESS_PKG.get_ass_action_context(paa.ASSIGNMENT_ID)
760: , 'ASSIGNMENT_ID=C'
761: , paa.ASSIGNMENT_ID
762: ,'DATE_EARNED=C'
763: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
764: , 'PAYROLL_ACTION_ID=C'
765: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
766: FROM pay_payroll_actions ppa
767: , pay_assignment_actions paa