eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PL_PCP

Line 22747: -- and tr.where_clause = l_BEN_PL_PCP

22743: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22744: pqh_table_route tr
22745: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22746: and cpe.table_route_id = tr.table_route_id
22747: -- and tr.where_clause = l_BEN_PL_PCP
22748: and tr.table_alias = l_table_alias
22749: and cpe.number_of_copies = 1 -- ADDITION
22750: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
22751: order by information1, information2; --added for bug: 5151945

Line 22783: from BEN_PL_PCP PCP

22779: c_business_group_id number,
22780: c_new_pk_id number) is
22781: select
22782: PCP.pl_pcp_id new_value
22783: from BEN_PL_PCP PCP
22784: where
22785: PCP.PL_ID = l_PL_ID and
22786: PCP.business_group_id = c_business_group_id
22787: and PCP.pl_pcp_id <> c_new_pk_id

Line 22979: hr_utility.set_location(' BEN_PL_PCP CREATE_PL_PRMRY_CARE_PRVDR ',20);

22975: end if;
22976: --
22977: if l_first_rec and not l_update then
22978: -- Call Create routine.
22979: hr_utility.set_location(' BEN_PL_PCP CREATE_PL_PRMRY_CARE_PRVDR ',20);
22980: BEN_PL_PRMRY_CARE_PRVDR_API.CREATE_PL_PRMRY_CARE_PRVDR(
22981: --
22982: P_VALIDATE => false
22983: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)

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 25384: from ben_pl_pcp

25380: --
25381: --cursor to check the pcp_rpstry_flag
25382: cursor c_rpstry_flag(c_pl_pcp_id in number) is
25383: select pcp_rpstry_flag
25384: from ben_pl_pcp
25385: Where pl_pcp_id = c_pl_pcp_id;
25386:
25387: l_rpstry_flag ben_pl_pcp.pcp_rpstry_flag%type;
25388: --

Line 25387: l_rpstry_flag ben_pl_pcp.pcp_rpstry_flag%type;

25383: select pcp_rpstry_flag
25384: from ben_pl_pcp
25385: Where pl_pcp_id = c_pl_pcp_id;
25386:
25387: l_rpstry_flag ben_pl_pcp.pcp_rpstry_flag%type;
25388: --
25389: --UPD START
25390: --
25391: l_update boolean := false ;

Line 25467: if l_rpstry_flag = 'Y' then -- create PTY rows only if the Repository flag is selected in ben_pl_pcp

25463: fetch c_rpstry_flag into l_rpstry_flag;
25464: close c_rpstry_flag;
25465:
25466:
25467: if l_rpstry_flag = 'Y' then -- create PTY rows only if the Repository flag is selected in ben_pl_pcp
25468: --UPD START
25469: --
25470: if l_dml_operation = 'UPDATE' then
25471: --

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)

Line 27973: -- PCP records are intersection of PLN and ben_pl_pcp

27969: ,p_prefix_suffix_cd => p_prefix_suffix_cd
27970: );
27971: end if;
27972: --
27973: -- PCP records are intersection of PLN and ben_pl_pcp
27974: --
27975: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PCP') then
27976: BEN_PD_COPY_TO_BEN_TWO.create_PCP_rows(
27977: p_validate => p_validate