APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_GRADE_RULES_F

Line 13505: WHERE pdt.table_name = 'PAY_GRADE_RULES_F'

13501: AND ppe.surrogate_key = p_grade_id
13502: AND EXISTS (SELECT 1
13503: FROM pay_dated_tables pdt
13504: ,pay_event_updates peu
13505: WHERE pdt.table_name = 'PAY_GRADE_RULES_F'
13506: AND peu.dated_table_id = pdt.dated_table_id
13507: AND peu.change_type = ppe.change_type
13508: AND peu.event_update_id = ppe.event_update_id
13509: )

Line 13526: l_grd_type pay_grade_rules_f.rate_type%TYPE:='N';

13522: RETURN VARCHAR2
13523: IS
13524:
13525: l_index pay_element_types_f.element_type_id%TYPE;
13526: l_grd_type pay_grade_rules_f.rate_type%TYPE:='N';
13527: l_proc_name varchar2(61) := g_proc_name || 'get_grade_sp_type';
13528:
13529: CURSOR csr_chk_pay_src(p_ele_id NUMBER) IS
13530: SELECT petf.element_type_id

Line 17285: FROM pay_grade_rules_f

17281: ,effective_end_date
17282: ,rate_id
17283: ,grade_or_spinal_point_id
17284: ,rate_type
17285: FROM pay_grade_rules_f
17286: WHERE grade_rule_id = p_grade_rule_id
17287: AND p_effective_date BETWEEN effective_start_date
17288: AND effective_end_date;
17289: