APPS.GHR_PAY_CAPS dependencies on PAY_USER_TABLES

Line 288: function pay_cap_chk_ttl_38(l_user_table_id IN pay_user_tables.user_table_id%TYPE,

284: --
285:
286: --Bug# 5132113
287:
288: function pay_cap_chk_ttl_38(l_user_table_id IN pay_user_tables.user_table_id%TYPE,
289: l_user_clomun_name IN pay_user_columns.user_column_name%TYPE,
290: l_market_pay IN number,
291: p_effective_date IN ghr_pa_Requests.effective_date%TYPE)
292: RETURN BOOLEAN IS

Line 297: pay_user_tables udt,

293: CURSOR range_values is
294: SELECT udr.row_low_range_or_name,udr.row_high_range
295: FROM pay_user_columns udc,
296: pay_user_rows_f udr,
297: pay_user_tables udt,
298: pay_user_column_instances_f uci
299: WHERE udt.user_table_id = l_user_table_id
300: AND udr.user_table_id = udt.user_table_id
301: AND NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN udr.effective_start_date AND udr.effective_end_date