APPS.GHR_CPDF_EHRIS dependencies on PAY_USER_TABLES

Line 788: from pay_user_tables

784: order by pei.person_extra_info_id;
785:
786: Cursor c_retained_pay_table_name (p_user_table_id number) is
787: select substr(user_table_name,1,4) user_table_name
788: from pay_user_tables
789: where user_table_id = p_user_table_id;
790:
791:
792: l_proc varchar2(30) := 'get_from_history_peopei';

Line 1210: from pay_user_tables

1206: g_pay_table_name := null;
1207: if (l_POSIEI_DATA.POEI_INFORMATION5 is not null) then
1208: select substr(user_table_name,1,4)
1209: into l_to_pay_table_id
1210: from pay_user_tables
1211: where user_table_id = l_POSIEI_DATA.POEI_INFORMATION5;
1212: g_pay_table_name := l_to_pay_table_id;
1213: end if;
1214:

Line 3461: FROM pay_user_tables

3457: -- FWFA Changes Declare variable l_calc_pay_table_id
3458:
3459: Cursor c_pay_table_name (p_user_table_id number) is
3460: SELECT SUBSTR(user_table_name,1,4) user_table_name
3461: FROM pay_user_tables
3462: WHERE user_table_id = p_user_table_id;
3463:
3464: l_calc_pay_table_id VARCHAR2(4);
3465: