APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_PLIP_F

Line 39: from BEN_PLIP_F plip,

35:
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

Line 55: from BEN_PLIP_F plip,

51: select pln.pl_id,
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 )

Line 1685: -- BEN_PLIP_F as their parent_entity_result_id

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
1689: -- All children of BEN_PL_F will have the copy_entity_result_id of

Line 1702: l_out_pln_cpp_result_id := l_out_cpp_result_id; -- Copy_entity_result_id of Ben_Plip_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:
1705: -- ------------------------------------------------------------------------
1706: end if;

Line 1966: l_out_pln_cpp_result_id := l_out_cpp_result_id; -- Copy_entity_result_id of Ben_Plip_f

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:
1969: -- To pass as effective date while creating the
1970: -- non date-tracked child records

Line 6312: from ben_plip_f plip

6308: select ERP.enrt_perd_for_pl_id
6309: from BEN_ENRT_PERD_FOR_PL_F ERP
6310: where ENRT_PERD_ID = c_ENRT_PERD_ID
6311: and exists (select null
6312: from ben_plip_f plip
6313: where plip.pl_id = ERP.pl_id
6314: and plip.pgm_id = c_pgm_id
6315: and ERP.effective_start_date between
6316: plip.effective_start_date and plip.effective_end_date);

Line 6416: from ben_plip_f plip

6412: select enrt_perd_for_pl_id
6413: from BEN_ENRT_PERD_FOR_PL_F ERP
6414: where LEE_RSN_ID = c_LEE_RSN_ID
6415: and exists (select null
6416: from ben_plip_f plip
6417: where plip.pl_id = ERP.pl_id
6418: and plip.pgm_id = c_pgm_id
6419: and ERP.effective_start_date between
6420: plip.effective_start_date and plip.effective_end_date);