APPS.GHR_CPDF_STATRPT dependencies on PAY_USER_TABLES

Line 5: g_retained_pay_table_id pay_user_tables.user_table_id%TYPE;

1: PACKAGE BODY ghr_cpdf_statrpt AS
2: /* $Header: ghrcpdfs.pkb 120.16.12020000.2 2012/12/05 05:51:50 utokachi ship $ */
3:
4: g_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE;
5: g_retained_pay_table_id pay_user_tables.user_table_id%TYPE;
6:
7: PROCEDURE initialize_record
8: IS
9: l_proc varchar2(30) := 'initialize_record';

Line 1307: FROM pay_user_tables

1303: ll_per_ei_data per_people_extra_info%rowtype;
1304: -- FWFA Changes Declare variable l_calc_pay_table_id
1305: Cursor c_pay_table_name (p_user_table_id number) is
1306: SELECT SUBSTR(user_table_name,1,4) user_table_name
1307: FROM pay_user_tables
1308: WHERE user_table_id = p_user_table_id;
1309: l_calc_pay_table_id VARCHAR2(4);
1310: -- This function returns true if the Pay Plan passed in is an 'GS' equivalent
1311: FUNCTION pp_gs_equivalent (p_pay_plan IN VARCHAR2)