DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_CUST_REV_DIST_LINES_ALL

Line 2406: from pa_cust_rev_dist_lines_all rdl

2402: for rdl_lines in (
2403: select nvl(rdl.retn_draft_invoice_line_num, -1) retention_line_num,
2404: nvl(rdl.retention_rule_id,-1) retention_rule_id,
2405: sum(nvl(rdl.retained_amount,0)) retained_amount
2406: from pa_cust_rev_dist_lines_all rdl
2407: where project_id = p_project_id
2408: AND draft_invoice_num = p_draft_invoice_num
2409: AND draft_invoice_item_line_num = inv_lines.line_num
2410: group by nvl(rdl.retn_draft_invoice_line_num,-1) , nvl(rdl.retention_rule_id,-1) ) LOOP