DBA Data[Home] [Help]

APPS.PER_SALADMIN_UTILITY dependencies on PAY_GRADE_RULES_F

Line 590: l_grade_currency pay_grade_rules_f.currency_code%type :=null ;

586:
587: FUNCTION get_grade_currency (p_grade_id in number,p_rate_id in number,p_effective_date in date,p_business_group_id in number )
588: RETURN VARCHAR2
589: is
590: l_grade_currency pay_grade_rules_f.currency_code%type :=null ;
591:
592: cursor csr_grade_currency is
593: select grdrule.currency_code
594: from pay_grade_rules_f grdrule

Line 594: from pay_grade_rules_f grdrule

590: l_grade_currency pay_grade_rules_f.currency_code%type :=null ;
591:
592: cursor csr_grade_currency is
593: select grdrule.currency_code
594: from pay_grade_rules_f grdrule
595: where grdrule.rate_id = p_rate_id
596: and grdrule.grade_or_spinal_point_id = p_grade_id
597: and p_effective_date between grdrule.effective_start_date
598: and grdrule.effective_end_date;