DBA Data[Home] [Help]

APPS.IGS_AU_GEN_003 dependencies on IGS_OR_UNIT_HIST_ALL

Line 376: p_org_unit_cd IN IGS_OR_UNIT_HIST_ALL.institution_cd%TYPE ,

372:
373:
374: FUNCTION Audp_Get_Ouh_Col(
375: p_column_name IN user_tab_columns.column_name%TYPE ,
376: p_org_unit_cd IN IGS_OR_UNIT_HIST_ALL.institution_cd%TYPE ,
377: p_ou_start_dt IN IGS_OR_UNIT_HIST_ALL.ou_start_dt%TYPE ,
378: p_hist_end_dt IN IGS_OR_UNIT_HIST_ALL.hist_end_dt%TYPE )
379: RETURN VARCHAR2 AS
380: BEGIN -- audp_get_ouh_col

Line 377: p_ou_start_dt IN IGS_OR_UNIT_HIST_ALL.ou_start_dt%TYPE ,

373:
374: FUNCTION Audp_Get_Ouh_Col(
375: p_column_name IN user_tab_columns.column_name%TYPE ,
376: p_org_unit_cd IN IGS_OR_UNIT_HIST_ALL.institution_cd%TYPE ,
377: p_ou_start_dt IN IGS_OR_UNIT_HIST_ALL.ou_start_dt%TYPE ,
378: p_hist_end_dt IN IGS_OR_UNIT_HIST_ALL.hist_end_dt%TYPE )
379: RETURN VARCHAR2 AS
380: BEGIN -- audp_get_ouh_col
381: -- get the oldest column value (after a given date) for a

Line 378: p_hist_end_dt IN IGS_OR_UNIT_HIST_ALL.hist_end_dt%TYPE )

374: FUNCTION Audp_Get_Ouh_Col(
375: p_column_name IN user_tab_columns.column_name%TYPE ,
376: p_org_unit_cd IN IGS_OR_UNIT_HIST_ALL.institution_cd%TYPE ,
377: p_ou_start_dt IN IGS_OR_UNIT_HIST_ALL.ou_start_dt%TYPE ,
378: p_hist_end_dt IN IGS_OR_UNIT_HIST_ALL.hist_end_dt%TYPE )
379: RETURN VARCHAR2 AS
380: BEGIN -- audp_get_ouh_col
381: -- get the oldest column value (after a given date) for a
382: -- specified column and institution_cd for IGS_OR_UNIT_HIST table