APPS.HRI_APL_DGNSTC_OPEN_ENRT dependencies on HRI_APL_DGNSTC_OPEN_ENRT

Line 1: PACKAGE BODY hri_apl_dgnstc_open_enrt AS

1: PACKAGE BODY hri_apl_dgnstc_open_enrt AS
2: /* $Header: hriadgoe.pkb 120.1 2005/11/16 08:53:45 nhunur noship $ */
3: --
4: FUNCTION get_pgm_for_open_le
5: RETURN VARCHAR2

Line 472: OR hri_apl_dgnstc_open_enrt.pgm_has_pln_with_rqd_actn_item (pgm.pgm_id,

468: AND pgc.effective_end_date)
469: )
470: )
471: )
472: OR hri_apl_dgnstc_open_enrt.pgm_has_pln_with_rqd_actn_item (pgm.pgm_id,
473: :p_end_date ,
474: pgm.dpnt_dsgn_lvl_cd) = ''Y''
475: OR EXISTS (
476: SELECT 1

Line 539: END hri_apl_dgnstc_open_enrt;

535: RETURN l_sql_stmt;
536: --
537: END get_pgm_with_inactive_status;
538: --
539: END hri_apl_dgnstc_open_enrt;