DBA Data[Home] [Help]

APPS.HR_US_REPORTS dependencies on PAY_PAYMENT_TYPES

Line 782: FROM pay_payment_types_tl ppt_tl,

778: begin
779: hr_utility.set_location('hr_us_reports.get_payment_type_name',5);
780: SELECT ppt_tl.payment_type_name
781: INTO l_payment_type_name
782: FROM pay_payment_types_tl ppt_tl,
783: pay_payment_types ppt
784: WHERE ppt_tl.payment_type_id = ppt.payment_type_id
785: and userenv('LANG') = ppt_tl.language
786: and ppt.payment_type_id = p_payment_type_id;

Line 783: pay_payment_types ppt

779: hr_utility.set_location('hr_us_reports.get_payment_type_name',5);
780: SELECT ppt_tl.payment_type_name
781: INTO l_payment_type_name
782: FROM pay_payment_types_tl ppt_tl,
783: pay_payment_types ppt
784: WHERE ppt_tl.payment_type_id = ppt.payment_type_id
785: and userenv('LANG') = ppt_tl.language
786: and ppt.payment_type_id = p_payment_type_id;
787: --