APPS.IGS_AU_GEN_003 dependencies on IGS_OR_UNIT_HIST

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

Line 382: -- specified column and institution_cd for IGS_OR_UNIT_HIST table

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
383: DECLARE
384: cst_ou_end_dt VARCHAR2(10) := 'OU_END_DT';
385: cst_description VARCHAR2(11) := 'DESCRIPTION';
386: cst_org_status VARCHAR2(10) := 'ORG_STATUS';

Line 402: FROM IGS_OR_UNIT_HIST ouh

398: cst_org_type, ouh.ORG_TYPE,
399: cst_member_type, ouh.MEMBER_TYPE,
400: cst_INSTITUTION_CD, ouh.institution_cd,
401: cst_name, ouh.NAME)
402: FROM IGS_OR_UNIT_HIST ouh
403: WHERE ouh.org_unit_cd = p_org_unit_cd AND
404: ouh.ou_start_dt = p_ou_start_dt AND
405: ouh.hist_start_dt >= p_hist_end_dt AND
406: DECODE (