DBA Data[Home] [Help]

APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on PAY_ELEMENT_TYPES_F

Line 639: from pay_element_types_f

635: --
636: cursor c_get_et_currency_cd (l_element_type_id in number)
637: is
638: select input_currency_code
639: from pay_element_types_f
640: where element_type_id = l_element_type_id
641: and p_effective_date between effective_start_date
642: and effective_end_date;
643: --

Line 647: from pay_element_types_f et

643: --
644: cursor c_get_sb_currency_cd
645: is
646: select et.input_currency_code
647: from pay_element_types_f et
648: ,per_pay_bases pb
649: ,pay_input_values_f iv
650: ,per_all_assignments_f asg
651: where asg.pay_basis_id = pb.pay_basis_id