APPS.PAY_NL_RETRO_SETUP_REPORT dependencies on PER_BUSINESS_GROUPS

Line 121: CURSOR csr_bg_name(c_bg_id per_business_groups.name%TYPE, c_eff_date DATE) IS

117:
118:
119:
120: -- Getting BG name
121: CURSOR csr_bg_name(c_bg_id per_business_groups.name%TYPE, c_eff_date DATE) IS
122:
123: SELECT name FROM per_business_groups
124: WHERE business_group_id = c_bg_id
125: AND c_eff_date BETWEEN date_from AND NVL(date_to,hr_general.end_of_time);

Line 123: SELECT name FROM per_business_groups

119:
120: -- Getting BG name
121: CURSOR csr_bg_name(c_bg_id per_business_groups.name%TYPE, c_eff_date DATE) IS
122:
123: SELECT name FROM per_business_groups
124: WHERE business_group_id = c_bg_id
125: AND c_eff_date BETWEEN date_from AND NVL(date_to,hr_general.end_of_time);
126:
127: -- Local Variables