APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PL_PCP_TYP

Line 25422: l_GNDR_ALWD_CD ben_pl_pcp_typ.gndr_alwd_cd%type;

25418: ,p_prefix_suffix_cd in varchar2 default null
25419: ) is
25420: --
25421: l_PL_PCP_ID number;
25422: l_GNDR_ALWD_CD ben_pl_pcp_typ.gndr_alwd_cd%type;
25423: l_MAX_AGE ben_pl_pcp_typ.max_age%type;
25424: l_MIN_AGE ben_pl_pcp_typ.min_age%type;
25425: l_PCP_TYP_CD ben_pl_pcp_typ.pcp_typ_cd%type;
25426:

Line 25423: l_MAX_AGE ben_pl_pcp_typ.max_age%type;

25419: ) is
25420: --
25421: l_PL_PCP_ID number;
25422: l_GNDR_ALWD_CD ben_pl_pcp_typ.gndr_alwd_cd%type;
25423: l_MAX_AGE ben_pl_pcp_typ.max_age%type;
25424: l_MIN_AGE ben_pl_pcp_typ.min_age%type;
25425: l_PCP_TYP_CD ben_pl_pcp_typ.pcp_typ_cd%type;
25426:
25427: cursor c_unique_PTY(l_table_alias varchar2) is

Line 25424: l_MIN_AGE ben_pl_pcp_typ.min_age%type;

25420: --
25421: l_PL_PCP_ID number;
25422: l_GNDR_ALWD_CD ben_pl_pcp_typ.gndr_alwd_cd%type;
25423: l_MAX_AGE ben_pl_pcp_typ.max_age%type;
25424: l_MIN_AGE ben_pl_pcp_typ.min_age%type;
25425: l_PCP_TYP_CD ben_pl_pcp_typ.pcp_typ_cd%type;
25426:
25427: cursor c_unique_PTY(l_table_alias varchar2) is
25428: select distinct cpe.information1,

Line 25425: l_PCP_TYP_CD ben_pl_pcp_typ.pcp_typ_cd%type;

25421: l_PL_PCP_ID number;
25422: l_GNDR_ALWD_CD ben_pl_pcp_typ.gndr_alwd_cd%type;
25423: l_MAX_AGE ben_pl_pcp_typ.max_age%type;
25424: l_MIN_AGE ben_pl_pcp_typ.min_age%type;
25425: l_PCP_TYP_CD ben_pl_pcp_typ.pcp_typ_cd%type;
25426:
25427: cursor c_unique_PTY(l_table_alias varchar2) is
25428: select distinct cpe.information1,
25429: cpe.information2,

Line 25436: -- and tr.where_clause = l_BEN_PL_PCP_TYP

25432: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25433: pqh_table_route tr
25434: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25435: and cpe.table_route_id = tr.table_route_id
25436: -- and tr.where_clause = l_BEN_PL_PCP_TYP
25437: and tr.table_alias = l_table_alias
25438: and cpe.number_of_copies = 1 -- ADDITION
25439: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
25440: order by information1, information2; --added for bug: 5151945

Line 25472: from BEN_PL_PCP_TYP PTY

25468: c_business_group_id number,
25469: c_new_pk_id number) is
25470: select
25471: PTY.pl_pcp_typ_id new_value
25472: from BEN_PL_PCP_TYP PTY
25473: where
25474: PTY.PL_PCP_ID = l_PL_PCP_ID and
25475: NVL(PTY.GNDR_ALWD_CD,-999) = NVL(l_GNDR_ALWD_CD,-999) and
25476: NVL(PTY.MAX_AGE,-999) = NVL(l_MAX_AGE,-999) and

Line 25646: hr_utility.set_location(' BEN_PL_PCP_TYP CREATE_PL_CARE_PRVDR_TYP ',20);

25642: end if ;
25643: --
25644: if l_first_rec and not l_update then
25645: -- Call Create routine.
25646: hr_utility.set_location(' BEN_PL_PCP_TYP CREATE_PL_CARE_PRVDR_TYP ',20);
25647: BEN_PL_CARE_PRVDR_TYP_API.CREATE_PL_CARE_PRVDR_TYP(
25648: --
25649: P_VALIDATE => false
25650: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)