APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PL_PCP_TYP

Line 25320: l_GNDR_ALWD_CD ben_pl_pcp_typ.gndr_alwd_cd%type;

25316: ,p_prefix_suffix_cd in varchar2 default null
25317: ) is
25318: --
25319: l_PL_PCP_ID number;
25320: l_GNDR_ALWD_CD ben_pl_pcp_typ.gndr_alwd_cd%type;
25321: l_MAX_AGE ben_pl_pcp_typ.max_age%type;
25322: l_MIN_AGE ben_pl_pcp_typ.min_age%type;
25323: l_PCP_TYP_CD ben_pl_pcp_typ.pcp_typ_cd%type;
25324:

Line 25321: l_MAX_AGE ben_pl_pcp_typ.max_age%type;

25317: ) is
25318: --
25319: l_PL_PCP_ID number;
25320: l_GNDR_ALWD_CD ben_pl_pcp_typ.gndr_alwd_cd%type;
25321: l_MAX_AGE ben_pl_pcp_typ.max_age%type;
25322: l_MIN_AGE ben_pl_pcp_typ.min_age%type;
25323: l_PCP_TYP_CD ben_pl_pcp_typ.pcp_typ_cd%type;
25324:
25325: cursor c_unique_PTY(l_table_alias varchar2) is

Line 25322: l_MIN_AGE ben_pl_pcp_typ.min_age%type;

25318: --
25319: l_PL_PCP_ID number;
25320: l_GNDR_ALWD_CD ben_pl_pcp_typ.gndr_alwd_cd%type;
25321: l_MAX_AGE ben_pl_pcp_typ.max_age%type;
25322: l_MIN_AGE ben_pl_pcp_typ.min_age%type;
25323: l_PCP_TYP_CD ben_pl_pcp_typ.pcp_typ_cd%type;
25324:
25325: cursor c_unique_PTY(l_table_alias varchar2) is
25326: select distinct cpe.information1,

Line 25323: l_PCP_TYP_CD ben_pl_pcp_typ.pcp_typ_cd%type;

25319: l_PL_PCP_ID number;
25320: l_GNDR_ALWD_CD ben_pl_pcp_typ.gndr_alwd_cd%type;
25321: l_MAX_AGE ben_pl_pcp_typ.max_age%type;
25322: l_MIN_AGE ben_pl_pcp_typ.min_age%type;
25323: l_PCP_TYP_CD ben_pl_pcp_typ.pcp_typ_cd%type;
25324:
25325: cursor c_unique_PTY(l_table_alias varchar2) is
25326: select distinct cpe.information1,
25327: cpe.information2,

Line 25334: -- and tr.where_clause = l_BEN_PL_PCP_TYP

25330: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25331: pqh_table_route tr
25332: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25333: and cpe.table_route_id = tr.table_route_id
25334: -- and tr.where_clause = l_BEN_PL_PCP_TYP
25335: and tr.table_alias = l_table_alias
25336: and cpe.number_of_copies = 1 -- ADDITION
25337: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
25338: order by information1, information2; --added for bug: 5151945

Line 25370: from BEN_PL_PCP_TYP PTY

25366: c_business_group_id number,
25367: c_new_pk_id number) is
25368: select
25369: PTY.pl_pcp_typ_id new_value
25370: from BEN_PL_PCP_TYP PTY
25371: where
25372: PTY.PL_PCP_ID = l_PL_PCP_ID and
25373: NVL(PTY.GNDR_ALWD_CD,-999) = NVL(l_GNDR_ALWD_CD,-999) and
25374: NVL(PTY.MAX_AGE,-999) = NVL(l_MAX_AGE,-999) and

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

25540: end if ;
25541: --
25542: if l_first_rec and not l_update then
25543: -- Call Create routine.
25544: hr_utility.set_location(' BEN_PL_PCP_TYP CREATE_PL_CARE_PRVDR_TYP ',20);
25545: BEN_PL_CARE_PRVDR_TYP_API.CREATE_PL_CARE_PRVDR_TYP(
25546: --
25547: P_VALIDATE => false
25548: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)