DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_USER_INIT dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 172: FROM pay_shadow_element_types

168: ,cp_element_name VARCHAR2 ) IS
169: SELECT element_type_id
170: ,object_version_number
171: ,payroll_formula_id
172: FROM pay_shadow_element_types
173: WHERE template_id = cp_template_id
174: AND element_name = cp_element_name;
175:
176: CURSOR get_proc_priority ( cp_legislation_code VARCHAR2

Line 193: FROM pay_shadow_element_types

189: AND rule_type = 'SEP_CHEQUE_IV';
190:
191: CURSOR get_shd_formula_id ( cp_template_id NUMBER ) IS
192: SELECT payroll_formula_id
193: FROM pay_shadow_element_types
194: WHERE template_id = cp_template_id
195: AND payroll_formula_id IS NOT NULL;
196:
197: CURSOR get_formula_info ( cp_formula_id NUMBER ) IS

Line 406: FROM pay_shadow_element_types pset

402: IF lv_rule_mode IS NOT NULL THEN
403:
404: SELECT COUNT(*)
405: INTO ln_iv_exists
406: FROM pay_shadow_element_types pset
407: ,pay_shadow_input_values psiv
408: WHERE pset.template_id = l_source_template_id
409: AND psiv.element_type_id = pset.element_type_id
410: AND psiv.name = lv_rule_mode;