APPS.IGS_AU_GEN_004 dependencies on IGS_PS_UNIT_VER_HIST

Line 277: p_unit_cd IGS_PS_UNIT_VER_HIST_ALL.unit_cd%TYPE ,

273: -- Added auditable_ind, audit_permission_ind and max_auditors_allowed
274: -- parameters in SELECT statement as per Bug# 2636716 by shtatiko.
275:
276: Function Audp_Get_Uvh_Col(
277: p_unit_cd IGS_PS_UNIT_VER_HIST_ALL.unit_cd%TYPE ,
278: p_version_number IGS_PS_UNIT_VER_HIST_ALL.version_number%TYPE ,
279: p_column_name user_tab_columns.column_name%TYPE ,
280: p_hist_date IGS_PS_UNIT_VER_HIST_ALL.hist_end_dt%TYPE )
281: RETURN VARCHAR2 AS

Line 278: p_version_number IGS_PS_UNIT_VER_HIST_ALL.version_number%TYPE ,

274: -- parameters in SELECT statement as per Bug# 2636716 by shtatiko.
275:
276: Function Audp_Get_Uvh_Col(
277: p_unit_cd IGS_PS_UNIT_VER_HIST_ALL.unit_cd%TYPE ,
278: p_version_number IGS_PS_UNIT_VER_HIST_ALL.version_number%TYPE ,
279: p_column_name user_tab_columns.column_name%TYPE ,
280: p_hist_date IGS_PS_UNIT_VER_HIST_ALL.hist_end_dt%TYPE )
281: RETURN VARCHAR2 AS
282:

Line 280: p_hist_date IGS_PS_UNIT_VER_HIST_ALL.hist_end_dt%TYPE )

276: Function Audp_Get_Uvh_Col(
277: p_unit_cd IGS_PS_UNIT_VER_HIST_ALL.unit_cd%TYPE ,
278: p_version_number IGS_PS_UNIT_VER_HIST_ALL.version_number%TYPE ,
279: p_column_name user_tab_columns.column_name%TYPE ,
280: p_hist_date IGS_PS_UNIT_VER_HIST_ALL.hist_end_dt%TYPE )
281: RETURN VARCHAR2 AS
282:
283: BEGIN -- audp_get_uvh_col
284: -- get the oldest column value (after a given date) for a

Line 457: FROM IGS_PS_UNIT_VER_HIST uvh

453: l_c_ovrd_wkld_val_flag, uvh.ovrd_wkld_val_flag,
454: l_c_workload_val_code, uvh.workload_val_code,
455: l_c_billing_hrs, TO_CHAR(uvh.billing_hrs)
456: )
457: FROM IGS_PS_UNIT_VER_HIST uvh
458: WHERE uvh.unit_cd = p_unit_cd AND
459: uvh.version_number = p_version_number AND
460: uvh.hist_start_dt >= p_hist_date AND
461: DECODE (p_column_name,