APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_GRADE_RULES_F

Line 13306: WHERE pdt.table_name = 'PAY_GRADE_RULES_F'

13302: AND ppe.surrogate_key = p_grade_id
13303: AND EXISTS (SELECT 1
13304: FROM pay_dated_tables pdt
13305: ,pay_event_updates peu
13306: WHERE pdt.table_name = 'PAY_GRADE_RULES_F'
13307: AND peu.dated_table_id = pdt.dated_table_id
13308: AND peu.change_type = ppe.change_type
13309: AND peu.event_update_id = ppe.event_update_id
13310: )

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

13323: RETURN VARCHAR2
13324: IS
13325:
13326: l_index pay_element_types_f.element_type_id%TYPE;
13327: l_grd_type pay_grade_rules_f.rate_type%TYPE:='N';
13328: l_proc_name varchar2(61) := g_proc_name || 'get_grade_sp_type';
13329:
13330: CURSOR csr_chk_pay_src(p_ele_id NUMBER) IS
13331: SELECT petf.element_type_id

Line 16916: FROM pay_grade_rules_f

16912: ,effective_end_date
16913: ,rate_id
16914: ,grade_or_spinal_point_id
16915: ,rate_type
16916: FROM pay_grade_rules_f
16917: WHERE grade_rule_id = p_grade_rule_id
16918: AND p_effective_date BETWEEN effective_start_date
16919: AND effective_end_date;
16920: