DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_USER_INIT dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 158: FROM pay_shadow_element_types

154: ,cp_element_name VARCHAR2 ) IS
155: SELECT element_type_id
156: ,object_version_number
157: ,payroll_formula_id
158: FROM pay_shadow_element_types
159: WHERE template_id = cp_template_id
160: AND element_name = cp_element_name;
161:
162: CURSOR get_proc_priority ( cp_legislation_code VARCHAR2

Line 179: FROM pay_shadow_element_types

175: AND rule_type = 'SEP_CHEQUE_IV';
176:
177: CURSOR get_shd_formula_id ( cp_template_id NUMBER ) IS
178: SELECT payroll_formula_id
179: FROM pay_shadow_element_types
180: WHERE template_id = cp_template_id
181: AND payroll_formula_id IS NOT NULL;
182:
183: CURSOR get_formula_info ( cp_formula_id NUMBER ) IS

Line 332: FROM pay_shadow_element_types pset

328: IF lv_rule_mode IS NOT NULL THEN
329:
330: SELECT COUNT(*)
331: INTO ln_iv_exists
332: FROM pay_shadow_element_types pset
333: ,pay_shadow_input_values psiv
334: WHERE pset.template_id = l_source_template_id
335: AND psiv.element_type_id = pset.element_type_id
336: AND psiv.name = lv_rule_mode;