DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_CUST_EVENT_RDL_ALL

Line 2354: from pa_cust_event_rdl_all erdl

2350: for erdl_lines in (
2351: select nvl(erdl.retn_draft_invoice_line_num, -1) retention_line_num,
2352: nvl(erdl.retention_rule_id,-1) retention_rule_id,
2353: nvl(sum(nvl(erdl.retained_amount,0)),0) retained_amount
2354: from pa_cust_event_rdl_all erdl
2355: where project_id = p_project_id
2356: AND draft_invoice_num = p_draft_invoice_num
2357: AND draft_invoice_item_line_num = inv_lines.line_num
2358: group by nvl(erdl.retn_draft_invoice_line_num,-1) , nvl(erdl.retention_rule_id,-1) ) LOOP