APPS.PAY_CA_WF_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 897: from pay_element_types_f_tl

893: where classification_id = to_number(p_ele_element_class);
894:
895: cursor cur_ele_element_name is
896: select element_name
897: from pay_element_types_f_tl
898: where element_type_id = to_number(p_ele_element_name)
899: and language = userenv('LANG');
900:
901: cursor cur_ele_employee is

Line 915: from pay_element_types_f

911: where classification_id = to_number(p_deduction_class);
912:
913: cursor cur_ded_name is
914: select element_name
915: from pay_element_types_f
916: where element_type_id = to_number(p_deduction_name)
917: and fnd_date.canonical_to_date(p_date_earned)
918: between effective_start_date and effective_end_date;
919:

Line 1009: from pay_element_types_f el, pay_element_types_f_tl tl

1005: where classification_id = to_number(p_cost_detail_class);
1006:
1007: cursor cur_costing_detail_ele_name is
1008: select tl.element_name
1009: from pay_element_types_f el, pay_element_types_f_tl tl
1010: where el.element_type_id = to_number(p_cost_detail_element)
1011: and el.element_type_id = tl.element_type_id
1012: and tl.language = userenv('LANG')
1013: and fnd_date.canonical_to_date(p_date_earned)

Line 3026: from pay_element_types_f_tl

3022: where classification_id = to_number(p_ele_element_class);
3023:
3024: cursor cur_ele_element_name is
3025: select element_name
3026: from pay_element_types_f_tl
3027: where element_type_id = to_number(p_ele_element_name)
3028: and language = userenv('LANG');
3029:
3030: cursor cur_ele_employee is

Line 3044: from pay_element_types_f

3040: where classification_id = to_number(p_deduction_class);
3041:
3042: cursor cur_ded_name is
3043: select element_name
3044: from pay_element_types_f
3045: where element_type_id = to_number(p_deduction_name)
3046: and fnd_date.canonical_to_date(p_date_earned)
3047: between effective_start_date and effective_end_date;
3048:

Line 3138: from pay_element_types_f el, pay_element_types_f_tl tl

3134: where classification_id = to_number(p_cost_detail_class);
3135:
3136: cursor cur_costing_detail_ele_name is
3137: select tl.element_name
3138: from pay_element_types_f el, pay_element_types_f_tl tl
3139: where el.element_type_id = to_number(p_cost_detail_element)
3140: and el.element_type_id = tl.element_type_id
3141: and tl.language = userenv('LANG')
3142: and fnd_date.canonical_to_date(p_date_earned)