APPS.PA_RES_ASG_CURRENCY_PUB dependencies on PA_BUDGET_LINES

Line 1552: FROM pa_budget_lines bl,

1548: bl.txn_currency_code
1549: BULK COLLECT
1550: INTO l_ra_id_tab,
1551: l_txn_currency_code_tab
1552: FROM pa_budget_lines bl,
1553: pa_resource_assignments ra
1554: WHERE ra.budget_version_id = p_fp_cols_rec.x_budget_version_id
1555: AND bl.resource_assignment_id = ra.resource_assignment_id
1556: AND NOT EXISTS (SELECT null

Line 1844: pa_budget_lines bl,

1840: 0,null,sum(nvl(bl.init_revenue,0))), --TOTAL_PROJFUNC_INIT_REVENUE
1841: decode(sum(nvl(bl.display_quantity,0)),
1842: 0,null,sum(nvl(bl.display_quantity,0))) --TOTAL_DISPLAY_QUANTITY
1843: FROM pa_resource_assignments ra,
1844: pa_budget_lines bl,
1845: pa_resource_asgn_curr rbc
1846: WHERE bl.resource_assignment_id = rbc.resource_assignment_id (+)
1847: AND bl.txn_currency_code = rbc.txn_currency_code (+)
1848: AND ra.budget_version_id = c_budget_version_id

Line 1892: FROM pa_budget_lines bl

1888: null --TOTAL_DISPLAY_QUANTITY
1889: FROM pa_resource_asgn_curr rbc
1890: WHERE rbc.budget_version_id = c_budget_version_id
1891: AND NOT EXISTS (SELECT null
1892: FROM pa_budget_lines bl
1893: WHERE bl.resource_assignment_id = rbc.resource_assignment_id
1894: AND bl.txn_currency_code = rbc.txn_currency_code );
1895:
1896:

Line 2005: FROM pa_budget_lines bl,

2001: decode(sum(nvl(bl.init_revenue,0)),
2002: 0,null,sum(nvl(bl.init_revenue,0))), --TOTAL_PROJFUNC_INIT_REVENUE
2003: decode(sum(nvl(bl.display_quantity,0)),
2004: 0,null,sum(nvl(bl.display_quantity,0))) --TOTAL_DISPLAY_QUANTITY
2005: FROM pa_budget_lines bl,
2006: pa_resource_asgn_curr_TMP rbc
2007: WHERE bl.resource_assignment_id (+) = rbc.resource_assignment_id
2008: AND bl.txn_currency_code (+) = rbc.txn_currency_code
2009: GROUP BY rbc.resource_assignment_id,