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.PO_PA_INTEGRATION_GRP dependencies on FND_DATE

Line 658: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=

654: where exists(
655: SELECT po_header_id,po_line_id
656: FROM po_sp_val_v
657: where person_id = p_person_id
658: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=
659: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_start_date))
660: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=
661: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_expiration_date))
662: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=

Line 659: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_start_date))

655: SELECT po_header_id,po_line_id
656: FROM po_sp_val_v
657: where person_id = p_person_id
658: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=
659: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_start_date))
660: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=
661: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_expiration_date))
662: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=
663: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_start_date))

Line 660: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=

656: FROM po_sp_val_v
657: where person_id = p_person_id
658: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=
659: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_start_date))
660: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=
661: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_expiration_date))
662: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=
663: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_start_date))
664: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=

Line 661: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_expiration_date))

657: where person_id = p_person_id
658: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=
659: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_start_date))
660: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=
661: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_expiration_date))
662: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=
663: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_start_date))
664: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=
665: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_end_date))

Line 662: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=

658: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=
659: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_start_date))
660: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=
661: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_expiration_date))
662: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=
663: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_start_date))
664: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=
665: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_end_date))
666: AND po_header_id = p_po_header_id

Line 663: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_start_date))

659: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_start_date))
660: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=
661: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_expiration_date))
662: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=
663: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_start_date))
664: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=
665: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_end_date))
666: AND po_header_id = p_po_header_id
667: AND po_line_id = p_po_line_id

Line 664: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=

660: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=
661: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_expiration_date))
662: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=
663: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_start_date))
664: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=
665: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_end_date))
666: AND po_header_id = p_po_header_id
667: AND po_line_id = p_po_line_id
668: );

Line 665: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_end_date))

661: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_expiration_date))
662: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=
663: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_start_date))
664: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=
665: fnd_date.canonical_to_date(fnd_date.date_to_canonical(assignmt_effective_end_date))
666: AND po_header_id = p_po_header_id
667: AND po_line_id = p_po_line_id
668: );
669: