DBA Data[Home] [Help]

APPS.PER_SALADMIN_UTILITY dependencies on PAY_GRADE_RULES_F

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

617:
618: 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 )
619: RETURN VARCHAR2
620: is
621: l_grade_currency pay_grade_rules_f.currency_code%type :=null ;
622:
623: cursor csr_grade_currency is
624: select grdrule.currency_code
625: from pay_grade_rules_f grdrule

Line 625: from pay_grade_rules_f grdrule

621: l_grade_currency pay_grade_rules_f.currency_code%type :=null ;
622:
623: cursor csr_grade_currency is
624: select grdrule.currency_code
625: from pay_grade_rules_f grdrule
626: where grdrule.rate_id = p_rate_id
627: and grdrule.grade_or_spinal_point_id = p_grade_id
628: and p_effective_date between grdrule.effective_start_date
629: and grdrule.effective_end_date;