APPS.PA_INVOICE_ACTIONS dependencies on PA_CUST_REV_DIST_LINES

Line 905: FROM pa_cust_rev_dist_lines rdl

901: AND dr.released_date IS NULL
902: AND dr.draft_revenue_num <=
903: /* Commented code fix for bug 2968645
904: (SELECT max(rdl.draft_revenue_num)
905: FROM pa_cust_rev_dist_lines rdl
906: WHERE rdl.project_id = P_Project_ID
907: AND rdl.draft_invoice_num = P_Draft_Invoice_Num); */
908: /* Bug fix for bug 2968645 Starts here */
909: (SELECT max(rdl1.draft_revenue_num)

Line 910: FROM pa_cust_rev_dist_lines rdl1

906: WHERE rdl.project_id = P_Project_ID
907: AND rdl.draft_invoice_num = P_Draft_Invoice_Num); */
908: /* Bug fix for bug 2968645 Starts here */
909: (SELECT max(rdl1.draft_revenue_num)
910: FROM pa_cust_rev_dist_lines rdl1
911: WHERE rdl1. expenditure_item_id in
912: ( SELECT expenditure_item_id
913: FROM pa_cust_rev_dist_lines rdl2
914: WHERE rdl2.project_id = P_Project_ID

Line 913: FROM pa_cust_rev_dist_lines rdl2

909: (SELECT max(rdl1.draft_revenue_num)
910: FROM pa_cust_rev_dist_lines rdl1
911: WHERE rdl1. expenditure_item_id in
912: ( SELECT expenditure_item_id
913: FROM pa_cust_rev_dist_lines rdl2
914: WHERE rdl2.project_id = P_Project_ID
915: AND rdl2.draft_invoice_num = P_Draft_Invoice_Num));
916: /* Bug fix for bug 2968645 Ends here */
917:

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