DBA Data[Home] [Help]

APPS.PAY_PAYUSDED_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 140: from pay_element_types_f

136: then
137: l_message := 'Error: While Selecting Element name ....';
138: select element_name
139: into c_element_name
140: from pay_element_types_f
141: where element_type_id = p_element_type_id
142: and p_end_date between effective_start_date and effective_end_date;
143: else
144: c_element_name := '';

Line 330: from pay_element_types_f pet1

326: where petr.element_set_id = cp_element_set_id
327: and petr.include_or_exclude = 'I'
328: union all
329: select pet1.element_type_id
330: from pay_element_types_f pet1
331: where pet1.classification_id in
332: (select classification_id
333: from pay_ele_classification_rules
334: where element_set_id = cp_element_set_id)