DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_CUST_REV_DIST_LINES_ALL

Line 2534: from pa_cust_rev_dist_lines_all rdl

2530: for rdl_lines in (
2531: select nvl(rdl.retn_draft_invoice_line_num, -1) retention_line_num,
2532: nvl(rdl.retention_rule_id,-1) retention_rule_id,
2533: sum(nvl(rdl.retained_amount,0)) retained_amount
2534: from pa_cust_rev_dist_lines_all rdl
2535: where project_id = p_project_id
2536: AND draft_invoice_num = p_draft_invoice_num
2537: AND draft_invoice_item_line_num = inv_lines.line_num
2538: group by nvl(rdl.retn_draft_invoice_line_num,-1) , nvl(rdl.retention_rule_id,-1) ) LOOP