DBA Data[Home] [Help]

APPS.PAY_BAL_ADJUST dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 1528: pay_status_processing_rules_f spr

1524: p_formula_id number,p_out_name varchar2)
1525: is
1526: select input_value_id,frr.result_rule_type,frr.severity_level
1527: from pay_formula_result_rules_f frr,
1528: pay_status_processing_rules_f spr
1529: where spr.element_type_id= p_ele_type
1530: and spr.formula_id = p_formula_id
1531: and spr.status_processing_rule_id = frr.status_processing_rule_id
1532: and upper(frr.result_name) = upper(p_out_name)

Line 1609: from pay_status_processing_rules_f

1605: --
1606: -- get formula id
1607: select formula_id
1608: into l_formula_id
1609: from pay_status_processing_rules_f
1610: where element_type_id =p_ele_type
1611: and processing_rule='B'
1612: and p_effdate between effective_start_date and effective_end_date;
1613: