DBA Data[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_GRADE_RULES_F

Line 770: ,pay_grade_rules_f pgr

766: cursor csr_grade_rate (c_attribute_id number
767: ,c_effective_date date) is
768: select to_number(pgr.value)
769: from pqp_assignment_attributes_f paa
770: ,pay_grade_rules_f pgr
771: where paa.assignment_attribute_id = c_attribute_id
772: and pgr.grade_or_spinal_point_id = paa.tp_safeguarded_grade_id
773: and pgr.rate_id = paa.tp_safeguarded_rate_id
774: and c_effective_date between pgr.effective_start_date

Line 787: ,pay_grade_rules_f pgr

783: cursor csr_scale_rate (c_attribute_id number
784: ,c_effective_date date) is
785: select to_number(pgr.value)
786: from pqp_assignment_attributes_f paa
787: ,pay_grade_rules_f pgr
788: where paa.assignment_attribute_id = c_attribute_id
789: and pgr.rate_id = paa.tp_safeguarded_rate_id
790: and pgr.grade_or_spinal_point_id = paa.tp_safeguarded_spinal_point_id
791: and c_effective_date between pgr.effective_start_date