DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_CUST_EVENT_RDL_ALL

Line 2482: from pa_cust_event_rdl_all erdl

2478: for erdl_lines in (
2479: select nvl(erdl.retn_draft_invoice_line_num, -1) retention_line_num,
2480: nvl(erdl.retention_rule_id,-1) retention_rule_id,
2481: nvl(sum(nvl(erdl.retained_amount,0)),0) retained_amount
2482: from pa_cust_event_rdl_all erdl
2483: where project_id = p_project_id
2484: AND draft_invoice_num = p_draft_invoice_num
2485: AND draft_invoice_item_line_num = inv_lines.line_num
2486: group by nvl(erdl.retn_draft_invoice_line_num,-1) , nvl(erdl.retention_rule_id,-1) ) LOOP