DBA Data[Home] [Help]

APPS.GHR_PAY_CAPS dependencies on PAY_USER_COLUMNS

Line 305: l_user_clomun_name IN pay_user_columns.user_column_name%TYPE,

301:
302: --Bug# 5132113
303:
304: function pay_cap_chk_ttl_38(l_user_table_id IN pay_user_tables.user_table_id%TYPE,
305: l_user_clomun_name IN pay_user_columns.user_column_name%TYPE,
306: l_market_pay IN number,
307: p_effective_date IN ghr_pa_Requests.effective_date%TYPE)
308: RETURN BOOLEAN IS
309: CURSOR range_values is

Line 311: FROM pay_user_columns udc,

307: p_effective_date IN ghr_pa_Requests.effective_date%TYPE)
308: RETURN BOOLEAN IS
309: CURSOR range_values is
310: SELECT udr.row_low_range_or_name,udr.row_high_range
311: FROM pay_user_columns udc,
312: pay_user_rows_f udr,
313: pay_user_tables udt,
314: pay_user_column_instances_f uci
315: WHERE udt.user_table_id = l_user_table_id