APPS.PA_BGT_BASELINE_PKG dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 758: pa_cost_distribution_lines_all cdl,

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

Line 801: pa_cost_distribution_lines_all cdl1

797: or (ei.system_linkage_function = 'BTC'
798: /* 7531681 start */
799: and exists (select null
800: from pa_expenditure_items_all ei1,
801: pa_cost_distribution_lines_all cdl1
802: where ( cdl1.burden_sum_source_run_id = ei.burden_sum_dest_run_id
803: and cdl1.project_id = p_project_id
804: and ei1.expenditure_item_id = cdl1.expenditure_item_id
805: )

Line 862: pa_cost_distribution_lines_all cdl1,

858: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
859: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
860: /* 7531681 and exists (select null
861: from pa_expenditure_items_all ei1,
862: pa_cost_distribution_lines_all cdl1,
863: pa_aud_cost_dist_lines aud
864: --PA.M added outer join to cdl1 and aud plus changed the or to and
865: -- cos if there are no records in aud,
866: -- then this will not pick up the BTC txns

Line 903: pa_cost_distribution_lines_all cdl1

899: /*If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all */
900: /*Exists clause before fixing bug 3019361 is as follows
901: and exists (select null
902: from pa_bc_commitments_all bc,
903: pa_cost_distribution_lines_all cdl1
904: where cdl1.burden_sum_source_run_id = ei.burden_sum_dest_run_id
905: and bc.document_header_id = to_number(cdl1.system_reference2)
906: and bc.document_distribution_id = to_number(cdl1.system_reference3)))); --'ER'
907: */

Line 955: pa_cost_distribution_lines_all cdl,

951: --PA.M selecting -99 for parent bc pkt for CWK BTC EIs
952: ,decode(ei.system_linkage_function, 'BTC', decode(nvl(ei.po_line_id,-99), -99, null, -99), null)
953: from pa_expenditure_items_all ei,
954: -- pa_expenditures_all exp, -- 7531681
955: pa_cost_distribution_lines_all cdl,
956: gl_period_STATUSES gl,
957: pa_tasks pt
958: where cdl.project_id = p_project_id
959: and pt.task_id = ei.task_id

Line 998: pa_cost_distribution_lines_all cdl1

994: or (ei.system_linkage_function = 'BTC'
995: /* 7531681 start */
996: and exists (select null
997: from pa_expenditure_items_all ei1,
998: pa_cost_distribution_lines_all cdl1
999: where ( cdl1.burden_sum_source_run_id = ei.burden_sum_dest_run_id
1000: and cdl1.project_id = p_project_id
1001: and ei1.expenditure_item_id = cdl1.expenditure_item_id
1002: )

Line 1060: pa_cost_distribution_lines_all cdl1,

1056: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
1057: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
1058: /* 7531681 and exists (select null
1059: from pa_expenditure_items_all ei1,
1060: pa_cost_distribution_lines_all cdl1,
1061: pa_aud_cost_dist_lines aud
1062: --PA.M added outer join to cdl1 and aud plus changed the or to and
1063: -- cos if there are no records in aud,
1064: -- then this will not pick up the BTC txns

Line 1101: pa_cost_distribution_lines_all cdl1

1097: /*If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all */
1098: /*Exists clause before fixing bug 3019361 is as follows
1099: and exists (select null
1100: from pa_bc_commitments_all bc,
1101: pa_cost_distribution_lines_all cdl1
1102: where cdl1.burden_sum_source_run_id = ei.burden_sum_dest_run_id
1103: and bc.document_header_id = to_number(cdl1.system_reference2)
1104: and bc.document_distribution_id = to_number(cdl1.system_reference3)))); --'ER'
1105: */