DBA Data[Home] [Help]

APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 27: pay_status_processing_rules_f spr

23: fty.formula_type_id,
24: fty.formula_type_name
25: from ff_formulas_f fra,
26: ff_formula_types fty,
27: pay_status_processing_rules_f spr
28: where fty.formula_type_id = fra.formula_type_id
29: and fra.formula_id = spr.formula_id
30: and spr.assignment_status_type_id is null
31: and spr.element_type_id = c_element_type_id

Line 245: FROM pay_status_processing_rules_f

241: CURSOR c_status_proc_id
242: ( c_element_type_id IN NUMBER
243: ,c_formula_id IN NUMBER ) IS
244: SELECT status_processing_rule_id
245: FROM pay_status_processing_rules_f
246: WHERE element_type_id = c_element_type_id
247: AND formula_id = c_formula_id
248: AND trunc(p_scheme_start_date) BETWEEN
249: effective_start_date AND effective_end_date;