APPS.HR_JPBP_API dependencies on PER_BUSINESS_GROUPS

Line 191: l_legislation_code per_business_groups.legislation_code%TYPE;

187: --
188: l_proc varchar2(72) := g_package||'create_jp_educ_sit';
189: l_exists varchar2(2);
190: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE := 1;
191: l_legislation_code per_business_groups.legislation_code%TYPE;
192: l_segment2 per_analysis_criteria.segment2%TYPE := p_segment2;
193: l_segment3 per_analysis_criteria.segment3%TYPE := p_segment3;
194: l_segment4 per_analysis_criteria.segment4%TYPE := p_segment4;
195: l_segment5 per_analysis_criteria.segment5%TYPE := p_segment5;

Line 200: from per_business_groups pbg

196: l_segment6 per_analysis_criteria.segment6%TYPE := p_segment6;
197: --
198: cursor csr_bg is
199: select legislation_code
200: from per_business_groups pbg
201: where pbg.business_group_id = p_business_group_id;
202: --
203:
204: begin

Line 495: from per_business_groups pbg

491: l_legislation_code varchar2(150);
492: --
493: cursor csr_bg is
494: select legislation_code
495: from per_business_groups pbg
496: where pbg.business_group_id = p_business_group_id;
497: --
498:
499: begin

Line 1059: from per_business_groups pbg

1055: l_legislation_code varchar2(150);
1056: --
1057: cursor csr_bg is
1058: select legislation_code
1059: from per_business_groups pbg
1060: where pbg.business_group_id = p_business_group_id;
1061: --
1062:
1063: begin

Line 1660: from per_business_groups pbg

1656: l_apl_object_version_number number;
1657: --
1658: cursor csr_bg is
1659: select legislation_code
1660: from per_business_groups pbg
1661: where pbg.business_group_id = p_business_group_id;
1662: --
1663: begin
1664: --

Line 2187: from per_business_groups pbg

2183: l_legislation_code varchar2(150);
2184: --
2185: cursor csr_bg is
2186: select legislation_code
2187: from per_business_groups pbg
2188: where pbg.business_group_id = p_business_group_id;
2189: --
2190:
2191: begin