APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 134: ,pay_user_column_instances_f puci

130: CURSOR col_cur (in_claim_date IN DATE)IS
131: SELECT puc.user_column_name
132: FROM pay_user_columns puc
133: ,pay_user_tables put
134: ,pay_user_column_instances_f puci
135: WHERE puc.user_table_id = put.user_table_id
136: AND put.user_table_name = p_table_name
137: AND puc.user_column_id = puci.user_column_id
138: AND (put.business_group_id = p_business_group_id

Line 1187: l_value PAY_USER_COLUMN_INSTANCES_F.value%TYPE;

1183:
1184: l_effective_date DATE;
1185: l_range_or_match PAY_USER_TABLES.range_or_match%TYPE;
1186: l_table_id PAY_USER_TABLES.user_table_id%TYPE;
1187: l_value PAY_USER_COLUMN_INSTANCES_F.value%TYPE;
1188: g_leg_code VARCHAR2(2);
1189: cached BOOLEAN := FALSE;
1190: g_effective_date DATE := NULL;
1191:

Line 1246: FROM pay_user_column_instances_f CINST

1242: BEGIN
1243: hr_utility.set_location ('hruserdt.get_table_value', 4);
1244: SELECT CINST.value
1245: INTO l_value
1246: FROM pay_user_column_instances_f CINST
1247: , pay_user_columns C
1248: , pay_user_rows_f R
1249: , pay_user_tables TAB
1250: WHERE TAB.user_table_id = l_table_id

Line 1296: FROM pay_user_column_instances_f CINST

1292: CLOSE c_fuel_type;
1293:
1294: SELECT CINST.value
1295: INTO l_value
1296: FROM pay_user_column_instances_f CINST
1297: , pay_user_columns C
1298: , pay_user_rows_f R
1299: , pay_user_tables TAB
1300: WHERE TAB.user_table_id = l_table_id

Line 1346: from pay_user_column_instances_f CINST

1342: BEGIN
1343: hr_utility.set_location ('hruserdt.get_table_value', 5);
1344: select CINST.value
1345: into l_value
1346: from pay_user_column_instances_f CINST
1347: , pay_user_columns C
1348: , pay_user_rows_f R
1349: , pay_user_tables TAB
1350: where TAB.user_table_id = l_table_id