APPS.GHR_CPDF_EHRIS dependencies on PAY_USER_TABLES

Line 775: from pay_user_tables

771: order by pei.person_extra_info_id;
772:
773: Cursor c_retained_pay_table_name (p_user_table_id number) is
774: select substr(user_table_name,1,4) user_table_name
775: from pay_user_tables
776: where user_table_id = p_user_table_id;
777:
778:
779: l_proc varchar2(30) := 'get_from_history_peopei';

Line 1175: from pay_user_tables

1171: g_pay_table_name := null;
1172: if (l_POSIEI_DATA.POEI_INFORMATION5 is not null) then
1173: select substr(user_table_name,1,4)
1174: into l_to_pay_table_id
1175: from pay_user_tables
1176: where user_table_id = l_POSIEI_DATA.POEI_INFORMATION5;
1177: g_pay_table_name := l_to_pay_table_id;
1178: end if;
1179:

Line 3318: FROM pay_user_tables

3314: -- FWFA Changes Declare variable l_calc_pay_table_id
3315:
3316: Cursor c_pay_table_name (p_user_table_id number) is
3317: SELECT SUBSTR(user_table_name,1,4) user_table_name
3318: FROM pay_user_tables
3319: WHERE user_table_id = p_user_table_id;
3320:
3321: l_calc_pay_table_id VARCHAR2(4);
3322: