APPS.HR_GBNICAR dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 331: FROM pay_user_column_instances_f puc,

327: cp_primary_ind IN VARCHAR2,
328: cp_mileage_factor IN NUMBER,
329: cp_date IN DATE) is
330: SELECT puc.value
331: FROM pay_user_column_instances_f puc,
332: pay_user_columns col,
333: pay_user_rows_f ur,
334: pay_user_tables tab
335: WHERE tab.user_table_id = col.user_table_id

Line 348: FROM pay_user_column_instances_f puc,

344: 'S',DECODE(cp_age_factor,
345: 2,'CAR_2_OVER_4','CAR_2_UNDER_4'))
346: --MILEAGE BAND
347: AND ur.user_row_id = (SELECT ur.user_row_id
348: FROM pay_user_column_instances_f puc,
349: pay_user_columns col,
350: pay_user_tables tab,
351: pay_user_rows_f ur
352: WHERE col.user_table_id = tab.user_table_id