APPS.PAY_WF_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 813: from pay_element_types_f el, pay_element_types_f_tl tl

809: where classification_id = to_number(p_cost_detail_class);
810:
811: cursor cur_costing_detail_ele_name is
812: select tl.element_name
813: from pay_element_types_f el, pay_element_types_f_tl tl
814: where el.element_type_id = to_number(p_cost_detail_element)
815: and el.element_type_id = tl.element_type_id
816: and tl.language = userenv('LANG')
817: and fnd_date.canonical_to_date(p_date_earned)

Line 1234: from pay_element_types_f

1230: */
1231: Begin
1232: select element_name
1233: into lv_element_name
1234: from pay_element_types_f
1235: where element_type_id = p_element;
1236: Exception when others then
1237: hr_utility.trace('In exception: OTHERS ');
1238: null;

Line 2528: from pay_element_types_f el, pay_element_types_f_tl tl

2524: where classification_id = to_number(p_cost_detail_class);
2525:
2526: cursor cur_costing_detail_ele_name is
2527: select tl.element_name
2528: from pay_element_types_f el, pay_element_types_f_tl tl
2529: where el.element_type_id = to_number(p_cost_detail_element)
2530: and el.element_type_id = tl.element_type_id
2531: and tl.language = userenv('LANG')
2532: and fnd_date.canonical_to_date(p_date_earned)

Line 2964: from pay_element_types_f

2960: */
2961: Begin
2962: select element_name
2963: into lv_element_name
2964: from pay_element_types_f
2965: where element_type_id = p_element;
2966: Exception when others then
2967: hr_utility.trace('In exception: OTHERS ');
2968: null;