APPS.PQP_GB_OSP_FUNCTIONS dependencies on PAY_USER_TABLES

Line 35: g_entitlement_UDT_id pay_user_tables.user_table_id%TYPE;

31: g_element_type_id pay_element_type_extra_info.element_type_id%TYPE;
32: g_plan_id ben_pl_f.pl_id%TYPE;
33:
34: -- Cache for pqp_get_los_based_entitlements
35: g_entitlement_UDT_id pay_user_tables.user_table_id%TYPE;
36: g_entitlement_UOM pay_element_type_extra_info.eei_information8%TYPE;
37:
38: -- Cache for PQP_GB_GET_ABSENCE_SSP
39: --g_ssp_element_id pay_element_types_f.element_type_id%TYPE;

Line 204: g_entitlement_UDT_id := NULL;--pay_user_tables.user_table_id%TYPE

200: g_element_type_id := NULL;--pay_element_type_extra_info.element_type_id%TYPE
201: g_plan_id := NULL;--ben_pl_f.pl_id%TYPE
202:
203: -- Cache for pqp_get_los_based_entitlements
204: g_entitlement_UDT_id := NULL;--pay_user_tables.user_table_id%TYPE
205: g_entitlement_UOM := NULL;--pay_element_type_extra_info.eei_information8%TYPE
206:
207: -- Cache for PQP_GB_GET_ABSENCE_SSP
208: --g_ssp_element_id := NULL;--pay_element_types_f.element_type_id%TYPE

Line 4240: ---- from pay_user_tables put,

4236: ---- select count(pur.row_low_range_or_name)
4237: ---- from pay_user_rows_f pur
4238: ---- where pur.user_row_id in(
4239: ---- select distinct uci.user_row_id
4240: ---- from pay_user_tables put,
4241: ---- pay_user_columns puc,
4242: ---- pay_user_column_instances_f uci
4243: ---- where put.user_table_id = puc.user_table_id
4244: ---- and uci.user_column_id = puc.user_column_id

Line 4265: -- FROM pay_user_tables put

4261: -- SELECT COUNT(pur.row_low_range_or_name)
4262: -- FROM pay_user_rows_f pur
4263: -- WHERE pur.user_row_id IN(
4264: -- SELECT DISTINCT uci.user_row_id
4265: -- FROM pay_user_tables put
4266: -- ,pay_user_columns puc
4267: -- ,pay_user_column_instances_f uci
4268: -- ,per_business_groups_perf pbg
4269: -- WHERE put.user_table_name = g_udt_name