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.PQP_PENSION_PROVIDERS dependencies on PQP_PENSION_TYPES_F

Line 653: from pqp_pension_types_f

649: ) Is
650:
651: Cursor csr_pen_type Is
652: Select min(effective_start_date), max(effective_end_date)
653: from pqp_pension_types_f
654: where pension_type_id = p_pension_type_id;
655:
656: Cursor csr_org_info Is
657: Select rowid

Line 666: pqp_pension_types_f pty

662:
663: Cursor csr_assigned_pen_types Is
664: Select pty.pension_type_name
665: from hr_organization_information hoi,
666: pqp_pension_types_f pty
667: where hoi.org_information_context = 'PQP_NL_ER_PENSION_TYPES'
668: and hoi.org_information2 = to_char(p_pension_type_id)
669: and hoi.organization_id = p_organization_id
670: and to_char(pty.pension_type_id) = hoi.org_information2