APPS.BEN_EXT_THREAD dependencies on PER_BUSINESS_GROUPS

Line 664: from per_business_groups

660: and effective_end_date;
661:
662: cursor bus_c (p_bg_id number) is
663: select name
664: from per_business_groups
665: where organization_id = p_bg_id ;
666:
667: cursor c_plcy (l_pl_id Number , l_typ_cd varchar2) is
668: select a.plcy_r_grp

Line 765: l_business_group_name per_business_groups.name%TYPE;

761: and rcd.rcd_type_cd = 'L';
762:
763:
764: l_subtrl_cnt number ;
765: l_business_group_name per_business_groups.name%TYPE;
766: l_rule_type c_rule_type%rowtype;
767: l_outputs ff_exec.outputs_t;
768: l_dummy_var varchar2(1000) ;
769: l_proc varchar2(72) ;

Line 5003: from per_business_groups

4999:
5000:
5001: cursor c_bg is
5002: select business_group_id , name
5003: from per_business_groups
5004: where p_ext_global_flag = 'Y'
5005: or business_group_id = p_business_group_id
5006: ;
5007:

Line 5010: from per_business_groups

5006: ;
5007:
5008: cursor c_pbg is
5009: select business_group_id , name
5010: from per_business_groups
5011: where business_group_id = p_business_group_id
5012: ;
5013:
5014:

Line 5019: l_proc_business_group_name per_business_groups.name%type ;

5015: l_include varchar2(1) ;
5016: l_person_id number ;
5017: l_business_group_id number ;
5018: l_proc_business_group_id number ;
5019: l_proc_business_group_name per_business_groups.name%type ;
5020:
5021: p_chg_actl_dt_from date ;
5022: p_chg_actl_dt_to date ;
5023: p_chg_eff_dt_from date ;

Line 6841: per_business_groups bg,

6837: CURSOR check_pqp_extract (c_ext_dfn_id IN NUMBER,
6838: c_business_group_id IN NUMBER) IS
6839: SELECT ea.ext_dfn_type
6840: FROM ben_ext_dfn ed,
6841: per_business_groups bg,
6842: pqp_extract_attributes ea
6843: WHERE ((bg.business_group_id = ed.business_group_id)OR
6844: (bg.legislation_code = ed.legislation_code) OR
6845: (ed.business_group_id IS NULL AND

Line 7183: from per_business_groups bg

7179: fnd.request_id = p_request_id;
7180: --
7181: cursor c_bg_name is
7182: select name
7183: from per_business_groups bg
7184: where business_group_id = p_business_group_id ;
7185:
7186: cursor c_ext is
7187: select name,business_group_id

Line 7191: l_business_goup_name per_business_groups.name%Type ;

7187: select name,business_group_id
7188: from ben_ext_file
7189: where ext_file_id = p_extract_file_id ;
7190:
7191: l_business_goup_name per_business_groups.name%Type ;
7192: l_request_id number ;
7193: l_business_group_name varchar2(2000) ;
7194: l_business_group_id number ;
7195: l_view_name varchar2(2000) ;