APPS.PA_REVENUE_AMT dependencies on PA_CUST_REV_DIST_LINES_ALL

Line 760: pa_cust_rev_dist_lines_all rdl

756: AND dr.request_id = p_request_id
757: AND EXISTS
758: ( SELECT NULL
759: FROM pa_expenditure_items_all x,
760: pa_cust_rev_dist_lines_all rdl
761: WHERE x.request_id+0 = dr.request_id
762: AND x.task_id = t.task_id
763: AND x.revenue_distributed_flag||'' = 'A'
764: AND x.raw_revenue = x.accrued_revenue

Line 785: pa_cust_rev_dist_lines_all rdl2

781: AND dr2.request_id+0 = p_request_id
782: AND EXISTS
783: ( SELECT NULL
784: FROM pa_expenditure_items_all ei2,
785: pa_cust_rev_dist_lines_all rdl2
786: WHERE ei2.request_id = rdl2.request_id
787: AND rdl2.expenditure_item_id = ei2.expenditure_item_id
788: AND ei2.raw_revenue is not NULL
789: AND ei2.accrued_revenue is not NULL

Line 821: from pa_cust_rev_dist_lines_all rdl,pa_expenditure_items_all ei,

817: rdl.draft_revenue_item_line_num,
818: rdl.draft_revenue_num,
819: ei.accrued_revenue ,
820: ei.raw_revenue
821: from pa_cust_rev_dist_lines_all rdl,pa_expenditure_items_all ei,
822: pa_tasks t
823: where p_top_task_id is not NULL
824: AND ei.request_id+0 = p_request_id
825: AND ei.raw_revenue is not NULL

Line 845: from pa_cust_rev_dist_lines_all rdl,pa_expenditure_items_all ei

841: rdl.draft_revenue_item_line_num,
842: rdl.draft_revenue_num,
843: ei.accrued_revenue ,
844: ei.raw_revenue
845: from pa_cust_rev_dist_lines_all rdl,pa_expenditure_items_all ei
846: where p_top_task_id is NULL
847: AND ei.request_id+0 = p_request_id
848: AND ei.raw_revenue is not NULL
849: AND ei.accrued_revenue is not NULL

Line 900: pa_cust_rev_dist_lines_all rdl

896: select /*+ LEADING ( T ) ORDERED USE_NL ( T EI RDL ) INDEX ( RDL PA_CUST_REV_DIST_LINES_N1 ) */ 'X'
897: into dummy_x
898: from pa_tasks t ,
899: pa_expenditure_items_all ei ,
900: pa_cust_rev_dist_lines_all rdl
901: where ei.request_id+0 = p_request_id
902: AND ei.raw_revenue is not NULL
903: AND ei.accrued_revenue is not NULL
904: AND ei.revenue_distributed_flag||'' = 'A'

Line 924: pa_cust_rev_dist_lines_all rdl

920: /*Modified the query for 9767275*/
921: select /*+ LEADING(EI) ORDERED INDEX ( RDL PA_CUST_REV_DIST_LINES_N1 ) */ 'X'
922: into dummy_x
923: from pa_expenditure_items_all ei ,
924: pa_cust_rev_dist_lines_all rdl
925: where ei.request_id+0 = p_request_id
926: AND ei.raw_revenue is not NULL
927: AND ei.accrued_revenue is not NULL
928: AND ei.revenue_distributed_flag||'' = 'A'||''

Line 972: UPDATE pa_cust_rev_dist_lines_all l

968: BEGIN
969:
970: l_message_code := 'Error in update on pa_cut_rev_dist_lines_all';
971:
972: UPDATE pa_cust_rev_dist_lines_all l
973: SET l.amount = PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -
974: DECODE(code_combination_id, -1, roundoff_amount,
975: -2, roundoff_amount,
976: -roundoff_amount)),