APPS.PER_NL_ABSENCE_TRACK_PKG dependencies on PAY_USER_TABLES

Line 15: l_user_table_name pay_user_tables.user_table_name%TYPE;

11: p_return_status in out nocopy varchar2
12: ) IS
13:
14: l_business_group_id number;
15: l_user_table_name pay_user_tables.user_table_name%TYPE;
16:
17:
18: l_action pay_user_column_instances_f.value%TYPE;
19: l_time_period pay_user_column_instances_f.value%TYPE;

Line 34: pay_user_tables put

30: vp_user_table_name varchar2,
31: vp_effective_date date) IS
32: SELECT pur.row_low_range_or_name
33: FROM pay_user_rows_f pur,
34: pay_user_tables put
35: WHERE put.user_table_id=pur.user_table_id
36: and put.business_group_id = vp_business_group_id
37: and put.user_table_name =vp_user_table_name
38: and vp_effective_date between

Line 208: from pay_user_tables utab

204:
205: CURSOR c_abs_utab(vp_business_group_id varchar2,
206: vp_user_table_name varchar2) IS
207: select user_table_id,user_table_name
208: from pay_user_tables utab
209: where business_group_id =vp_business_group_id
210: and user_table_name =vp_user_table_name;
211: vc_abs_utab c_abs_utab%ROWTYPE;
212: