DBA Data[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_GRADE_RULES_F

Line 766: ,pay_grade_rules_f pgr

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

Line 783: ,pay_grade_rules_f pgr

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