APPS.BEN_EXT_THREAD dependencies on PER_BUSINESS_GROUPS

Line 662: from per_business_groups

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

Line 763: l_business_group_name per_business_groups.name%TYPE;

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

Line 5001: from per_business_groups

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

Line 5008: from per_business_groups

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

Line 5017: l_proc_business_group_name per_business_groups.name%type ;

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

Line 6800: per_business_groups bg,

6796: CURSOR check_pqp_extract (c_ext_dfn_id IN NUMBER,
6797: c_business_group_id IN NUMBER) IS
6798: SELECT ea.ext_dfn_type
6799: FROM ben_ext_dfn ed,
6800: per_business_groups bg,
6801: pqp_extract_attributes ea
6802: WHERE ((bg.business_group_id = ed.business_group_id)OR
6803: (bg.legislation_code = ed.legislation_code) OR
6804: (ed.business_group_id IS NULL AND

Line 7142: from per_business_groups bg

7138: fnd.request_id = p_request_id;
7139: --
7140: cursor c_bg_name is
7141: select name
7142: from per_business_groups bg
7143: where business_group_id = p_business_group_id ;
7144:
7145: cursor c_ext is
7146: select name,business_group_id

Line 7150: l_business_goup_name per_business_groups.name%Type ;

7146: select name,business_group_id
7147: from ben_ext_file
7148: where ext_file_id = p_extract_file_id ;
7149:
7150: l_business_goup_name per_business_groups.name%Type ;
7151: l_request_id number ;
7152: l_business_group_name varchar2(2000) ;
7153: l_business_group_id number ;
7154: l_view_name varchar2(2000) ;