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 236: FROM pay_status_processing_rules_f

232: CURSOR c_status_proc_id
233: ( c_element_type_id IN NUMBER
234: ,c_formula_id IN NUMBER ) IS
235: SELECT status_processing_rule_id
236: FROM pay_status_processing_rules_f
237: WHERE element_type_id = c_element_type_id
238: AND formula_id = c_formula_id
239: AND trunc(p_scheme_start_date) BETWEEN
240: effective_start_date AND effective_end_date;