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_UK_UNION_TEMPLATE dependencies on HR_ORGANIZATION_INFORMATION

Line 92: l_or_unnddn_id hr_organization_information.organization_id%TYPE;

88: l_ee_unnorg_id pay_element_type_extra_info.eei_information1%TYPE;
89: l_ee_unnddn_nm pay_element_type_extra_info.eei_information2%TYPE;
90: l_ee_rattyp_nm pay_element_type_extra_info.eei_information3%TYPE;
91:
92: l_or_unnddn_id hr_organization_information.organization_id%TYPE;
93: l_oi_unndat_dt hr_organization_information.org_information2%TYPE;
94:
95: l_ut_unnudt_nm pay_user_tables.user_table_name%TYPE;
96: l_ut_unnudt_id pay_user_tables.user_table_id%TYPE;

Line 93: l_oi_unndat_dt hr_organization_information.org_information2%TYPE;

89: l_ee_unnddn_nm pay_element_type_extra_info.eei_information2%TYPE;
90: l_ee_rattyp_nm pay_element_type_extra_info.eei_information3%TYPE;
91:
92: l_or_unnddn_id hr_organization_information.organization_id%TYPE;
93: l_oi_unndat_dt hr_organization_information.org_information2%TYPE;
94:
95: l_ut_unnudt_nm pay_user_tables.user_table_name%TYPE;
96: l_ut_unnudt_id pay_user_tables.user_table_id%TYPE;
97: l_ut_tbltyp_nm pay_user_tables.range_or_match%TYPE;

Line 219: -- ,hr_organization_information hoi

215:
216: -- CURSOR get_user_table_id is
217: -- SELECT to_number(hoi.org_information1)
218: -- FROM hr_all_organization_units hou
219: -- ,hr_organization_information hoi
220: -- WHERE hou.organization_id = hoi.organization_id
221: -- AND org_information_context = 'GB_TRADE_UNION_INFO'
222: -- AND hou.name = p_union_name;
223: