APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PER_GRADES

Line 7015: l_rate_name per_grades.name%type;

7011: l_lonsoc_allowance number;
7012: l_other_allowance number;
7013: l_basic_salary number;
7014: l_return number;
7015: l_rate_name per_grades.name%type;
7016:
7017: l_rate_nc number;
7018:
7019: -- 4336613 : OSLA_3A

Line 17702: FROM per_grades pgr,per_all_assignments_f paaf

17698: ) IS
17699: SELECT decode(c_allowance_type,'LONDON_ALLOWANCE_RULE',information6,
17700: 'SPECIAL_ALLOWANCE_RULE',information7
17701: ) indicator
17702: FROM per_grades pgr,per_all_assignments_f paaf
17703: WHERE paaf.assignment_id = c_assignment_id
17704: AND c_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
17705: AND paaf.grade_id = pgr.grade_id
17706: AND pgr.information_category = 'GB_PQP_PENSERV_GRADE_INFO';