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 22849: -- and tr.where_clause = l_BEN_PL_PCP

22845: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22846: pqh_table_route tr
22847: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22848: and cpe.table_route_id = tr.table_route_id
22849: -- and tr.where_clause = l_BEN_PL_PCP
22850: and tr.table_alias = l_table_alias
22851: and cpe.number_of_copies = 1 -- ADDITION
22852: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
22853: order by information1, information2; --added for bug: 5151945

Line 22885: from BEN_PL_PCP PCP

22881: c_business_group_id number,
22882: c_new_pk_id number) is
22883: select
22884: PCP.pl_pcp_id new_value
22885: from BEN_PL_PCP PCP
22886: where
22887: PCP.PL_ID = l_PL_ID and
22888: PCP.business_group_id = c_business_group_id
22889: and PCP.pl_pcp_id <> c_new_pk_id

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

23077: end if;
23078: --
23079: if l_first_rec and not l_update then
23080: -- Call Create routine.
23081: hr_utility.set_location(' BEN_PL_PCP CREATE_PL_PRMRY_CARE_PRVDR ',20);
23082: BEN_PL_PRMRY_CARE_PRVDR_API.CREATE_PL_PRMRY_CARE_PRVDR(
23083: --
23084: P_VALIDATE => false
23085: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)

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

25482: --
25483: --cursor to check the pcp_rpstry_flag
25484: cursor c_rpstry_flag(c_pl_pcp_id in number) is
25485: select pcp_rpstry_flag
25486: from ben_pl_pcp
25487: Where pl_pcp_id = c_pl_pcp_id;
25488:
25489: l_rpstry_flag ben_pl_pcp.pcp_rpstry_flag%type;
25490: --

Line 25489: l_rpstry_flag ben_pl_pcp.pcp_rpstry_flag%type;

25485: select pcp_rpstry_flag
25486: from ben_pl_pcp
25487: Where pl_pcp_id = c_pl_pcp_id;
25488:
25489: l_rpstry_flag ben_pl_pcp.pcp_rpstry_flag%type;
25490: --
25491: --UPD START
25492: --
25493: l_update boolean := false ;

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

25565: fetch c_rpstry_flag into l_rpstry_flag;
25566: close c_rpstry_flag;
25567:
25568:
25569: if l_rpstry_flag = 'Y' then -- create PTY rows only if the Repository flag is selected in ben_pl_pcp
25570: --UPD START
25571: --
25572: if l_dml_operation = 'UPDATE' then
25573: --

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)

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

28071: ,p_prefix_suffix_cd => p_prefix_suffix_cd
28072: );
28073: end if;
28074: --
28075: -- PCP records are intersection of PLN and ben_pl_pcp
28076: --
28077: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PCP') then
28078: BEN_PD_COPY_TO_BEN_TWO.create_PCP_rows(
28079: p_validate => p_validate