APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_POPL_ORG_F

Line 5994: -- START OF BEN_POPL_ORG_F ----------------------

5990: ---------------------------------------------------------------
5991: -- END OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------
5992: ---------------------------------------------------------------
5993: ---------------------------------------------------------------
5994: -- START OF BEN_POPL_ORG_F ----------------------
5995: ---------------------------------------------------------------
5996: cursor c_cpo_from_parent(c_PL_ID number, c_PGM_ID number ) is
5997: select popl_org_id
5998: from BEN_POPL_ORG_F

Line 5998: from BEN_POPL_ORG_F

5994: -- START OF BEN_POPL_ORG_F ----------------------
5995: ---------------------------------------------------------------
5996: cursor c_cpo_from_parent(c_PL_ID number, c_PGM_ID number ) is
5997: select popl_org_id
5998: from BEN_POPL_ORG_F
5999: --where PL_ID = c_PL_ID ;
6000: where ( c_PL_ID is not null and c_PL_ID = PL_ID ) or
6001: ( c_PGM_ID is not null and c_PGM_ID = PGM_ID);
6002: --

Line 6006: from BEN_POPL_ORG_F cpo

6002: --
6003: cursor c_cpo(c_popl_org_id number,c_mirror_src_entity_result_id number,
6004: c_table_alias varchar2) is
6005: select cpo.*
6006: from BEN_POPL_ORG_F cpo
6007: where cpo.popl_org_id = c_popl_org_id
6008: -- and cpo.business_group_id = p_business_group_id
6009: and not exists (
6010: select /*+ */ null

Line 6017: -- and trt.where_clause = 'BEN_POPL_ORG_F'

6013: where copy_entity_txn_id = p_copy_entity_txn_id
6014: -- and trt.table_route_id = cpe.table_route_id
6015: and ( -- c_mirror_src_entity_result_id is null or
6016: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6017: -- and trt.where_clause = 'BEN_POPL_ORG_F'
6018: and cpe.table_alias = c_table_alias
6019: and information1 = c_popl_org_id
6020: -- and information4 = cpo.business_group_id
6021: and information2 = cpo.effective_start_date

Line 6044: -- END OF BEN_POPL_ORG_F ----------------------

6040: where organization_id = c_organization_id;
6041:
6042: l_organization_start_date hr_all_organization_units.date_from%type;
6043: ---------------------------------------------------------------
6044: -- END OF BEN_POPL_ORG_F ----------------------
6045: ---------------------------------------------------------------
6046: ---------------------------------------------------------------
6047: -- START OF BEN_POPL_YR_PERD ----------------------
6048: ---------------------------------------------------------------

Line 7982: -- START OF BEN_POPL_ORG_F ----------------------

7978: ---------------------------------------------------------------
7979: -- END OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------
7980: ---------------------------------------------------------------
7981: ---------------------------------------------------------------
7982: -- START OF BEN_POPL_ORG_F ----------------------
7983: ---------------------------------------------------------------
7984: --
7985: --
7986: for l_parent_rec in c_cpo_from_parent(p_pl_id,p_pgm_id) loop

Line 8224: -- END OF BEN_POPL_ORG_F ----------------------

8220: -- END OF BEN_POPL_ORG_ROLE_F ----------------------
8221: ---------------------------------------------------------------
8222: end loop;
8223: ---------------------------------------------------------------
8224: -- END OF BEN_POPL_ORG_F ----------------------
8225: ---------------------------------------------------------------
8226: ---------------------------------------------------------------
8227: -- START OF BEN_POPL_YR_PERD ----------------------
8228: ---------------------------------------------------------------