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_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_PL_F

Line 40: BEN_PL_F PLN

36: cursor c_pln_from_parent(c_PLIP_ID number,c_pl_id number ) is
37: select distinct pln.pl_id,
38: null Information8
39: from BEN_PLIP_F plip,
40: BEN_PL_F PLN
41: where ( C_PLIP_ID is not null and plip.PLIP_ID = C_PLIP_ID )
42: and plip.pl_id=pln.pl_id
43: union
44: select distinct pln.pl_id,

Line 46: from BEN_PL_F PLN

42: and plip.pl_id=pln.pl_id
43: union
44: select distinct pln.pl_id,
45: 'PLNIP' Information8
46: from BEN_PL_F PLN
47: where ( C_PL_ID is not null and pln.PL_ID = C_PL_ID);
48:
49: /*
50: cursor c_pln_from_parent(c_PLIP_ID number,c_pl_id number ) is

Line 56: BEN_PL_F PLN,

52: ptp.name pl_typ_name,
53: hl.meaning Plan_Usage,
54: null Information8
55: from BEN_PLIP_F plip,
56: BEN_PL_F PLN,
57: ben_pl_typ_f ptp,
58: hr_lookups hl
59: where ( C_PLIP_ID is not null and plip.PLIP_ID = C_PLIP_ID )
60: and plip.pl_id=pln.pl_id

Line 69: from BEN_PL_F PLN,

65: select pln.pl_id,
66: ptp.name pl_typ_name,
67: hl.meaning Plan_Usage,
68: 'PLNIP' Information8
69: from BEN_PL_F PLN,
70: ben_pl_typ_f ptp,
71: hr_lookups hl
72: where ( C_PL_ID is not null and pln.PL_ID = C_PL_ID )
73: and pln.pl_typ_id = ptp.pl_typ_id

Line 81: from BEN_PL_F pln

77: --
78: cursor c_pln(c_pl_id number,c_mirror_src_entity_result_id number,
79: c_table_alias varchar2) is
80: select pln.*
81: from BEN_PL_F pln
82: where pln.pl_id = c_pl_id
83: -- and pln.business_group_id = p_business_group_id
84: and not exists (
85: select /*+ */ null

Line 92: -- and trt.where_clause = 'BEN_PL_F'

88: where copy_entity_txn_id = p_copy_entity_txn_id
89: -- and trt.table_route_id = cpe.table_route_id
90: and ( c_mirror_src_entity_result_id is null or
91: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
92: -- and trt.where_clause = 'BEN_PL_F'
93: and cpe.table_alias = c_table_alias
94: and information1 = c_pl_id
95: -- and information4 = pln.business_group_id
96: and information2 = pln.effective_start_date

Line 163: from ben_pl_f

159: --Mapping for CWB Group_pl_id
160: --
161: cursor c_grp_pl_name (p_group_pl_id in number) is
162: select name group_pl_name
163: from ben_pl_f
164: where pl_id = p_group_pl_id
165: and p_effective_date between effective_start_date and effective_end_date;
166:
167: l_mapping_id number;

Line 174: l_pln_esd ben_pl_f.effective_start_date%type;

170: l_mapping_column_name2 pqh_attributes.attribute_name%type;
171:
172: -- Mapping end for CWB
173:
174: l_pln_esd ben_pl_f.effective_start_date%type;
175:
176: ---------------------------------------------------------------
177: -- START OF BEN_PL_TYP_F ----------------------
178: ---------------------------------------------------------------

Line 181: from BEN_PL_F

177: -- START OF BEN_PL_TYP_F ----------------------
178: ---------------------------------------------------------------
179: cursor c_ptp_from_parent(c_PL_ID number) is
180: select pl_typ_id
181: from BEN_PL_F
182: where PL_ID = c_PL_ID ;
183: --
184:
185: l_pl_typ_id number(15);

Line 1462: p_parent_entity_result_id => null, -- Hide BEN_PL_F for HGrid

1458: p_copy_entity_result_id => l_copy_entity_result_id,
1459: p_copy_entity_txn_id => p_copy_entity_txn_id,
1460: p_result_type_cd => l_result_type_cd,
1461: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
1462: p_parent_entity_result_id => null, -- Hide BEN_PL_F for HGrid
1463: p_number_of_copies => l_number_of_copies,
1464: p_table_alias => 'PLN',
1465: p_table_route_id => l_table_route_id,
1466: p_information1 => l_pln_rec.pl_id,

Line 1683: -- For Plans in Program, BEN_PL_F will be hidden in the HGrid

1679:
1680: if l_result_type_cd = 'DISPLAY' and p_number_of_copies = 1 then
1681: -- ------------------------------------------------------------------------
1682:
1683: -- For Plans in Program, BEN_PL_F will be hidden in the HGrid
1684: -- All children of BEN_PL_F will have the copy_entity_result_id of
1685: -- BEN_PLIP_F as their parent_entity_result_id
1686:
1687: -- For Plans Not in Program or when Plan is the Top Node in the HGrid

Line 1684: -- All children of BEN_PL_F will have the copy_entity_result_id of

1680: if l_result_type_cd = 'DISPLAY' and p_number_of_copies = 1 then
1681: -- ------------------------------------------------------------------------
1682:
1683: -- For Plans in Program, BEN_PL_F will be hidden in the HGrid
1684: -- All children of BEN_PL_F will have the copy_entity_result_id of
1685: -- BEN_PLIP_F as their parent_entity_result_id
1686:
1687: -- For Plans Not in Program or when Plan is the Top Node in the HGrid
1688: -- BEN_PL_F will be displayed

Line 1688: -- BEN_PL_F will be displayed

1684: -- All children of BEN_PL_F will have the copy_entity_result_id of
1685: -- BEN_PLIP_F as their parent_entity_result_id
1686:
1687: -- For Plans Not in Program or when Plan is the Top Node in the HGrid
1688: -- BEN_PL_F will be displayed
1689: -- All children of BEN_PL_F will have the copy_entity_result_id of
1690: -- BEN_PL_F as their parent_entity_result_id
1691:
1692: --

Line 1689: -- All children of BEN_PL_F will have the copy_entity_result_id of

1685: -- BEN_PLIP_F as their parent_entity_result_id
1686:
1687: -- For Plans Not in Program or when Plan is the Top Node in the HGrid
1688: -- BEN_PL_F will be displayed
1689: -- All children of BEN_PL_F will have the copy_entity_result_id of
1690: -- BEN_PL_F as their parent_entity_result_id
1691:
1692: --
1693: -- All children of BEN_PL_F will have the copy_entity_result_id of

Line 1690: -- BEN_PL_F as their parent_entity_result_id

1686:
1687: -- For Plans Not in Program or when Plan is the Top Node in the HGrid
1688: -- BEN_PL_F will be displayed
1689: -- All children of BEN_PL_F will have the copy_entity_result_id of
1690: -- BEN_PL_F as their parent_entity_result_id
1691:
1692: --
1693: -- All children of BEN_PL_F will have the copy_entity_result_id of
1694: -- BEN_PL_F as their mirror_src_entity_result_id

Line 1693: -- All children of BEN_PL_F will have the copy_entity_result_id of

1689: -- All children of BEN_PL_F will have the copy_entity_result_id of
1690: -- BEN_PL_F as their parent_entity_result_id
1691:
1692: --
1693: -- All children of BEN_PL_F will have the copy_entity_result_id of
1694: -- BEN_PL_F as their mirror_src_entity_result_id
1695: --
1696:
1697: l_out_pln_result_id := l_copy_entity_result_id; -- Copy_entity_result_id of Ben_Pl_f

Line 1694: -- BEN_PL_F as their mirror_src_entity_result_id

1690: -- BEN_PL_F as their parent_entity_result_id
1691:
1692: --
1693: -- All children of BEN_PL_F will have the copy_entity_result_id of
1694: -- BEN_PL_F as their mirror_src_entity_result_id
1695: --
1696:
1697: l_out_pln_result_id := l_copy_entity_result_id; -- Copy_entity_result_id of Ben_Pl_f
1698:

Line 1697: l_out_pln_result_id := l_copy_entity_result_id; -- Copy_entity_result_id of Ben_Pl_f

1693: -- All children of BEN_PL_F will have the copy_entity_result_id of
1694: -- BEN_PL_F as their mirror_src_entity_result_id
1695: --
1696:
1697: l_out_pln_result_id := l_copy_entity_result_id; -- Copy_entity_result_id of Ben_Pl_f
1698:
1699: if p_pl_id is not null then -- Plan is Top Node
1700: l_out_pln_cpp_result_id := l_out_pln_result_id; -- Copy_entity_result_id of Ben_Pl_f
1701: else -- Plan in Program

Line 1700: l_out_pln_cpp_result_id := l_out_pln_result_id; -- Copy_entity_result_id of Ben_Pl_f

1696:
1697: l_out_pln_result_id := l_copy_entity_result_id; -- Copy_entity_result_id of Ben_Pl_f
1698:
1699: if p_pl_id is not null then -- Plan is Top Node
1700: l_out_pln_cpp_result_id := l_out_pln_result_id; -- Copy_entity_result_id of Ben_Pl_f
1701: else -- Plan in Program
1702: l_out_pln_cpp_result_id := l_out_cpp_result_id; -- Copy_entity_result_id of Ben_Plip_f
1703: end if;
1704:

Line 1964: l_out_pln_cpp_result_id := l_out_pln_result_id; -- Copy_entity_result_id of Ben_Pl_f

1960: end if;
1961: close c_parent_result;
1962:
1963: if p_pl_id is not null then -- Plan is Top Node
1964: l_out_pln_cpp_result_id := l_out_pln_result_id; -- Copy_entity_result_id of Ben_Pl_f
1965: else -- Plan in Program
1966: l_out_pln_cpp_result_id := l_out_cpp_result_id; -- Copy_entity_result_id of Ben_Plip_f
1967: end if;
1968:

Line 1977: l_mirror_src_entity_result_id := l_out_pln_result_id; -- Copy_entity_result_id of Ben_Pl_f

1973: close c_parent_esd;
1974:
1975: end if;
1976:
1977: l_mirror_src_entity_result_id := l_out_pln_result_id; -- Copy_entity_result_id of Ben_Pl_f
1978: l_parent_entity_result_id := l_out_pln_cpp_result_id;
1979:
1980: -- ------------------------------------------------------------------------
1981: -- Eligibility Profiles