APPS.IGS_AU_GEN_004 dependencies on IGS_PS_TCH_RESP_HIST

Line 14: p_unit_cd IGS_PS_TCH_RESP_HIST_ALL.unit_cd%TYPE ,

10: Removed the following 4 columns
11: BILLING_CREDIT_POINTS,BILLING_HRS,FIN_AID_CP,FIN_AID_HRS
12: from Function Audp_Get_Uvh_Col.*/
13: Function Audp_Get_Trh_Col(
14: p_unit_cd IGS_PS_TCH_RESP_HIST_ALL.unit_cd%TYPE ,
15: p_version_number IGS_PS_TCH_RESP_HIST_ALL.version_number%TYPE ,
16: p_org_unit_cd IGS_PS_TCH_RESP_HIST_ALL.org_unit_cd%TYPE ,
17: p_ou_start_dt IGS_PS_TCH_RESP_HIST_ALL.ou_start_dt%TYPE ,
18: p_hist_date IGS_PS_TCH_RESP_HIST_ALL.hist_start_dt%TYPE )

Line 15: p_version_number IGS_PS_TCH_RESP_HIST_ALL.version_number%TYPE ,

11: BILLING_CREDIT_POINTS,BILLING_HRS,FIN_AID_CP,FIN_AID_HRS
12: from Function Audp_Get_Uvh_Col.*/
13: Function Audp_Get_Trh_Col(
14: p_unit_cd IGS_PS_TCH_RESP_HIST_ALL.unit_cd%TYPE ,
15: p_version_number IGS_PS_TCH_RESP_HIST_ALL.version_number%TYPE ,
16: p_org_unit_cd IGS_PS_TCH_RESP_HIST_ALL.org_unit_cd%TYPE ,
17: p_ou_start_dt IGS_PS_TCH_RESP_HIST_ALL.ou_start_dt%TYPE ,
18: p_hist_date IGS_PS_TCH_RESP_HIST_ALL.hist_start_dt%TYPE )
19: RETURN NUMBER AS

Line 16: p_org_unit_cd IGS_PS_TCH_RESP_HIST_ALL.org_unit_cd%TYPE ,

12: from Function Audp_Get_Uvh_Col.*/
13: Function Audp_Get_Trh_Col(
14: p_unit_cd IGS_PS_TCH_RESP_HIST_ALL.unit_cd%TYPE ,
15: p_version_number IGS_PS_TCH_RESP_HIST_ALL.version_number%TYPE ,
16: p_org_unit_cd IGS_PS_TCH_RESP_HIST_ALL.org_unit_cd%TYPE ,
17: p_ou_start_dt IGS_PS_TCH_RESP_HIST_ALL.ou_start_dt%TYPE ,
18: p_hist_date IGS_PS_TCH_RESP_HIST_ALL.hist_start_dt%TYPE )
19: RETURN NUMBER AS
20:

Line 17: p_ou_start_dt IGS_PS_TCH_RESP_HIST_ALL.ou_start_dt%TYPE ,

13: Function Audp_Get_Trh_Col(
14: p_unit_cd IGS_PS_TCH_RESP_HIST_ALL.unit_cd%TYPE ,
15: p_version_number IGS_PS_TCH_RESP_HIST_ALL.version_number%TYPE ,
16: p_org_unit_cd IGS_PS_TCH_RESP_HIST_ALL.org_unit_cd%TYPE ,
17: p_ou_start_dt IGS_PS_TCH_RESP_HIST_ALL.ou_start_dt%TYPE ,
18: p_hist_date IGS_PS_TCH_RESP_HIST_ALL.hist_start_dt%TYPE )
19: RETURN NUMBER AS
20:
21: BEGIN -- audp_get_trh_col

Line 18: p_hist_date IGS_PS_TCH_RESP_HIST_ALL.hist_start_dt%TYPE )

14: p_unit_cd IGS_PS_TCH_RESP_HIST_ALL.unit_cd%TYPE ,
15: p_version_number IGS_PS_TCH_RESP_HIST_ALL.version_number%TYPE ,
16: p_org_unit_cd IGS_PS_TCH_RESP_HIST_ALL.org_unit_cd%TYPE ,
17: p_ou_start_dt IGS_PS_TCH_RESP_HIST_ALL.ou_start_dt%TYPE ,
18: p_hist_date IGS_PS_TCH_RESP_HIST_ALL.hist_start_dt%TYPE )
19: RETURN NUMBER AS
20:
21: BEGIN -- audp_get_trh_col
22: -- get the oldest column value (after a given date) of the

Line 26: v_column_value IGS_PS_TCH_RESP_HIST.percentage%TYPE := NULL;

22: -- get the oldest column value (after a given date) of the
23: -- percentage column for a specified unit_cd, version_number,
24: -- org_unit_cd, ou_start_dt and hist_start_dt.
25: DECLARE
26: v_column_value IGS_PS_TCH_RESP_HIST.percentage%TYPE := NULL;
27: CURSOR c_trh IS
28: SELECT trh.percentage
29: FROM IGS_PS_TCH_RESP_HIST trh
30: WHERE trh.unit_cd = p_unit_cd AND

Line 29: FROM IGS_PS_TCH_RESP_HIST trh

25: DECLARE
26: v_column_value IGS_PS_TCH_RESP_HIST.percentage%TYPE := NULL;
27: CURSOR c_trh IS
28: SELECT trh.percentage
29: FROM IGS_PS_TCH_RESP_HIST trh
30: WHERE trh.unit_cd = p_unit_cd AND
31: trh.version_number = p_version_number AND
32: trh.org_unit_cd = p_org_unit_cd AND
33: trh.ou_start_dt = p_ou_start_dt AND