DBA Data[Home] [Help]

APPS.GHR_PAY_CAPS dependencies on PAY_USER_COLUMNS

Line 289: l_user_clomun_name IN pay_user_columns.user_column_name%TYPE,

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
293: CURSOR range_values is

Line 295: FROM pay_user_columns udc,

291: p_effective_date IN ghr_pa_Requests.effective_date%TYPE)
292: RETURN BOOLEAN IS
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