DBA Data[Home] [Help]

APPS.PAY_CA_WF_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 619: from pay_element_types_f_tl

615: where classification_id = to_number(p_ele_element_class);
616:
617: cursor cur_ele_element_name is
618: select element_name
619: from pay_element_types_f_tl
620: where element_type_id = to_number(p_ele_element_name)
621: and language = userenv('LANG');
622:
623: cursor cur_ele_employee is

Line 637: from pay_element_types_f

633: where classification_id = to_number(p_deduction_class);
634:
635: cursor cur_ded_name is
636: select element_name
637: from pay_element_types_f
638: where element_type_id = to_number(p_deduction_name)
639: and fnd_date.canonical_to_date(p_date_earned)
640: between effective_start_date and effective_end_date;
641:

Line 731: from pay_element_types_f el, pay_element_types_f_tl tl

727: where classification_id = to_number(p_cost_detail_class);
728:
729: cursor cur_costing_detail_ele_name is
730: select tl.element_name
731: from pay_element_types_f el, pay_element_types_f_tl tl
732: where el.element_type_id = to_number(p_cost_detail_element)
733: and el.element_type_id = tl.element_type_id
734: and tl.language = userenv('LANG')
735: and fnd_date.canonical_to_date(p_date_earned)