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_GB_SS_ABSENCE_TEMPLATE dependencies on FND_LOOKUP_VALUES_VL

Line 11: (P_LOOKUP_TYPE fnd_lookup_values_vl.lookup_type%TYPE

7: g_proc_name varchar2(31) := 'pqp_gb_ss_absence_template.' ;
8: -- Cursor to fill the absence type table from lookup
9: --
10: cursor g_c_get_lookupdata
11: (P_LOOKUP_TYPE fnd_lookup_values_vl.lookup_type%TYPE
12: ,P_EFFECTIVE_START_DATE fnd_lookup_values_vl.start_date_active%TYPE
13: )
14: IS
15: select lookup_code abs_type_id,meaning abs_type_name

Line 12: ,P_EFFECTIVE_START_DATE fnd_lookup_values_vl.start_date_active%TYPE

8: -- Cursor to fill the absence type table from lookup
9: --
10: cursor g_c_get_lookupdata
11: (P_LOOKUP_TYPE fnd_lookup_values_vl.lookup_type%TYPE
12: ,P_EFFECTIVE_START_DATE fnd_lookup_values_vl.start_date_active%TYPE
13: )
14: IS
15: select lookup_code abs_type_id,meaning abs_type_name
16: from fnd_lookup_values_vl

Line 16: from fnd_lookup_values_vl

12: ,P_EFFECTIVE_START_DATE fnd_lookup_values_vl.start_date_active%TYPE
13: )
14: IS
15: select lookup_code abs_type_id,meaning abs_type_name
16: from fnd_lookup_values_vl
17: where lookup_type = P_LOOKUP_TYPE
18: and enabled_flag = 'Y'
19: and P_EFFECTIVE_START_DATE BETWEEN
20: nvl(start_date_active,P_EFFECTIVE_START_DATE)