APPS.HRENTMNT dependencies on PER_BUSINESS_GROUPS

Line 2799: FROM per_business_groups

2795:
2796: -- cursor added for 8870436
2797: CURSOR csr_leg_grp(p_business_group_id number) IS
2798: SELECT LEGISLATION_CODE
2799: FROM per_business_groups
2800: where business_group_id=p_business_group_id;
2801:
2802: l_rec_ee hrentmnt.t_ele_entry_rec;
2803: l_num_eevs number := 0;

Line 2966: FROM per_business_groups

2962:
2963: /*Cursor added for bug:7440183for getting leg code */
2964: CURSOR csr_leg_grp(p_business_group_id number) IS
2965: SELECT LEGISLATION_CODE
2966: FROM per_business_groups
2967: where business_group_id=p_business_group_id;
2968:
2969: --
2970: l_rec_ee hrentmnt.t_ele_entry_rec;

Line 3120: FROM per_business_groups

3116: WHERE assignment_id = p_assignment_id;
3117:
3118: CURSOR csr_leg_grp(p_business_group_id number) IS
3119: SELECT LEGISLATION_CODE
3120: FROM per_business_groups
3121: where business_group_id=p_business_group_id;
3122:
3123: CURSOR csr_ele_entry_details(p_element_entry_id number, p_date in date) IS
3124: SELECT *

Line 4131: per_business_groups_perf pbg,

4127: --
4128: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/ plr.rule_mode
4129: into l_adjust_ee_source
4130: from pay_legislation_rules plr,
4131: per_business_groups_perf pbg,
4132: per_all_assignments_f paf
4133: where paf.assignment_id = p_assignment_id
4134: and p_validation_start_date between paf.effective_start_date
4135: and paf.effective_end_date

Line 4652: FROM PER_BUSINESS_GROUPS_PERF bg,

4648: cursor csr_entry_info_category(b_assignment_id in number,
4649: b_effective_date in date,
4650: b_element_link_id in number) is
4651: SELECT dfc.descriptive_flex_context_code
4652: FROM PER_BUSINESS_GROUPS_PERF bg,
4653: PAY_ELEMENT_LINKS_F el,
4654: PAY_ELEMENT_TYPES_F et,
4655: PAY_ELEMENT_CLASSIFICATIONS ec,
4656: FND_DESCR_FLEX_CONTEXTS dfc