APPS.PA_BGT_BASELINE_PKG dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 756: pa_cost_distribution_lines_all cdl,

752: --PA.M selecting -99 for parent bc pkt for CWK BTC EIs
753: ,decode(ei.system_linkage_function, 'BTC', decode(nvl(ei.po_line_id,-99), -99, null, -99), null)
754: from pa_expenditure_items_all ei,
755: pa_expenditures_all exp,
756: pa_cost_distribution_lines_all cdl,
757: gl_period_STATUSES gl,
758: pa_tasks pt
759: where cdl.project_id = p_project_id
760: and pt.task_id = ei.task_id

Line 793: pa_cost_distribution_lines_all cdl1,

789: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
790: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
791: and exists (select null
792: from pa_expenditure_items_all ei1,
793: pa_cost_distribution_lines_all cdl1,
794: pa_aud_cost_dist_lines aud
795: --PA.M added outer join to cdl1 and aud plus changed the or to and
796: -- cos if there are no records in aud,
797: -- then this will not pick up the BTC txns

Line 821: pa_cost_distribution_lines_all cdl1

817: /*If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all */
818: /*Exists clause before fixing bug 3019361 is as follows
819: and exists (select null
820: from pa_bc_commitments_all bc,
821: pa_cost_distribution_lines_all cdl1
822: where cdl1.burden_sum_source_run_id = ei.burden_sum_dest_run_id
823: and bc.document_header_id = to_number(cdl1.system_reference2)
824: and bc.document_distribution_id = to_number(cdl1.system_reference3)))); --'ER'
825: */

Line 870: pa_cost_distribution_lines_all cdl,

866: --PA.M selecting -99 for parent bc pkt for CWK BTC EIs
867: ,decode(ei.system_linkage_function, 'BTC', decode(nvl(ei.po_line_id,-99), -99, null, -99), null)
868: from pa_expenditure_items_all ei,
869: pa_expenditures_all exp,
870: pa_cost_distribution_lines_all cdl,
871: gl_period_STATUSES gl,
872: pa_tasks pt
873: where cdl.project_id = p_project_id
874: and pt.task_id = ei.task_id

Line 907: pa_cost_distribution_lines_all cdl1,

903: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
904: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
905: and exists (select null
906: from pa_expenditure_items_all ei1,
907: pa_cost_distribution_lines_all cdl1,
908: pa_aud_cost_dist_lines aud
909: --PA.M added outer join to cdl1 and aud plus changed the or to and
910: -- cos if there are no records in aud,
911: -- then this will not pick up the BTC txns

Line 935: pa_cost_distribution_lines_all cdl1

931: /*If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all */
932: /*Exists clause before fixing bug 3019361 is as follows
933: and exists (select null
934: from pa_bc_commitments_all bc,
935: pa_cost_distribution_lines_all cdl1
936: where cdl1.burden_sum_source_run_id = ei.burden_sum_dest_run_id
937: and bc.document_header_id = to_number(cdl1.system_reference2)
938: and bc.document_distribution_id = to_number(cdl1.system_reference3)))); --'ER'
939: */