APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on PAY_ITERATIVE_RULES_F

Line 232: l_itr_result_name pay_iterative_rules_f.result_name%TYPE

228: l_iterative_rule_id NUMBER;
229: l_ovn_itr NUMBER;
230: l_itr_effective_start_dt DATE;
231: l_itr_effective_end_dt DATE;
232: l_itr_result_name pay_iterative_rules_f.result_name%TYPE
233: := 'L_STOPPER';
234: l_itr_rule_type pay_iterative_rules_f.iterative_rule_type%TYPE
235: := 'S';
236: l_exc_itr_rule_id VARCHAR2 (1);

Line 234: l_itr_rule_type pay_iterative_rules_f.iterative_rule_type%TYPE

230: l_itr_effective_start_dt DATE;
231: l_itr_effective_end_dt DATE;
232: l_itr_result_name pay_iterative_rules_f.result_name%TYPE
233: := 'L_STOPPER';
234: l_itr_rule_type pay_iterative_rules_f.iterative_rule_type%TYPE
235: := 'S';
236: l_exc_itr_rule_id VARCHAR2 (1);
237: l_emp_deduction_method hr_lookups.lookup_code%TYPE
238: := p_emp_deduction_method;

Line 3946: FROM pay_iterative_rules_f

3942: -- for this element type
3943: CURSOR csr_get_itr_info (c_element_type_id NUMBER)
3944: IS
3945: SELECT iterative_rule_id, object_version_number
3946: FROM pay_iterative_rules_f
3947: WHERE element_type_id = c_element_type_id;
3948:
3949: -- Cursor to get pension category
3950: CURSOR csr_get_pens_cat