DBA Data[Home] [Help]

APPS.PAY_US_ISETUP_EARN_DEDN dependencies on PAY_ELEMENT_TYPES_F

Line 202: pay_element_types_f et

198: ft.formula_type_name
199: FROM pay_status_processing_rules_f spr,
200: ff_formulas_f ff,
201: ff_formula_types ft,
202: pay_element_types_f et
203: WHERE et.element_type_id = p_element_type_id
204: AND spr.formula_id = ff.formula_id
205: AND ff.formula_type_id = ft.formula_type_id
206: AND spr.element_type_id = et.element_type_id;

Line 211: pay_element_types_f et

207: --
208: CURSOR csr_bg_name IS
209: SELECT name || ' GRP KF' grp_name
210: FROM per_business_groups bg,
211: pay_element_types_f et
212: WHERE et.business_group_id = p_element_type_id;
213: --
214: l_req_id NUMBER(10);
215: BEGIN