APPS.PA_INVOICE_ACTIONS dependencies on PA_PROJ_RETN_RULES
Line 2678: from pa_proj_retn_rules
2674: standard line on the line credit amount to get retention credit amount */
2675:
2676: select nvl(threshold_amount,0), nvl(retention_percentage,0), nvl(retention_amount,0)
2677: into l_threshold_amount, l_retention_percentage, l_retention_amount 2678: from pa_proj_retn_rules 2679: where retention_rule_id = p_retention_rule_id;
2680:
2681:
2682: if (l_threshold_amount <> 0) OR (l_retention_amount <> 0) then