DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_PROJ_RETN_RULES

Line 2550: from pa_proj_retn_rules

2546: standard line on the line credit amount to get retention credit amount */
2547:
2548: select nvl(threshold_amount,0), nvl(retention_percentage,0), nvl(retention_amount,0)
2549: into l_threshold_amount, l_retention_percentage, l_retention_amount
2550: from pa_proj_retn_rules
2551: where retention_rule_id = p_retention_rule_id;
2552:
2553:
2554: if (l_threshold_amount <> 0) OR (l_retention_amount <> 0) then