APPS.PA_RES_ASG_CURRENCY_PUB dependencies on PA_BUDGET_LINES

Line 1564: FROM pa_budget_lines bl,

1560: bl.txn_currency_code
1561: BULK COLLECT
1562: INTO l_ra_id_tab,
1563: l_txn_currency_code_tab
1564: FROM pa_budget_lines bl,
1565: pa_resource_assignments ra
1566: WHERE ra.budget_version_id = p_fp_cols_rec.x_budget_version_id
1567: AND bl.resource_assignment_id = ra.resource_assignment_id
1568: AND NOT EXISTS (SELECT null

Line 1859: pa_budget_lines bl,

1855: decode(sum(nvl(bl.display_quantity,0)),
1856: 0,null,sum(nvl(bl.display_quantity,0))), --TOTAL_DISPLAY_QUANTITY
1857: rbc.expenditure_type --Expenditure type for Enc
1858: FROM pa_resource_assignments ra,
1859: pa_budget_lines bl,
1860: pa_resource_asgn_curr rbc
1861: WHERE bl.resource_assignment_id = rbc.resource_assignment_id (+)
1862: AND bl.txn_currency_code = rbc.txn_currency_code (+)
1863: AND ra.budget_version_id = c_budget_version_id

Line 1909: FROM pa_budget_lines bl

1905: rbc.expenditure_type --Expenditure type for Enc
1906: FROM pa_resource_asgn_curr rbc
1907: WHERE rbc.budget_version_id = c_budget_version_id
1908: AND NOT EXISTS (SELECT null
1909: FROM pa_budget_lines bl
1910: WHERE bl.resource_assignment_id = rbc.resource_assignment_id
1911: AND bl.txn_currency_code = rbc.txn_currency_code );
1912:
1913:

Line 2025: FROM pa_budget_lines bl,

2021: 0,null,sum(nvl(bl.init_revenue,0))), --TOTAL_PROJFUNC_INIT_REVENUE
2022: decode(sum(nvl(bl.display_quantity,0)),
2023: 0,null,sum(nvl(bl.display_quantity,0))), --TOTAL_DISPLAY_QUANTITY
2024: rbc.expenditure_type --Direct cost expenditure type for EnC
2025: FROM pa_budget_lines bl,
2026: pa_resource_asgn_curr_TMP rbc
2027: WHERE bl.resource_assignment_id (+) = rbc.resource_assignment_id
2028: AND bl.txn_currency_code (+) = rbc.txn_currency_code
2029: --Bug 6160759