APPS.PA_FP_GEN_PUB dependencies on PA_SPREAD_CURVES_B

Line 1348: FROM pa_spread_curves_b

1344: VALUES ( l_ins_ra_id_tab(i) );
1345:
1346: SELECT spread_curve_id
1347: INTO l_fixed_date_curve_id
1348: FROM pa_spread_curves_b
1349: WHERE spread_curve_code = lc_fixed_date_code;
1350:
1351: -- SQL Repository Bug 4884824; SQL ID 14902330
1352: -- Fixed Full Index Scan violation by replacing

Line 1794: lc_FixedDate CONSTANT PA_SPREAD_CURVES_B.SPREAD_CURVE_CODE%TYPE := 'FIXED_DATE';

1790: IS
1791: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_GEN_PUB.MAINTAIN_FIXED_DATE_SP';
1792:
1793: /* String constant for the fixed date spread curve code */
1794: lc_FixedDate CONSTANT PA_SPREAD_CURVES_B.SPREAD_CURVE_CODE%TYPE := 'FIXED_DATE';
1795:
1796: /* This cursor picks up resource assignment id's for resource assignments
1797: * having a fixed date spread curve and at least two budget lines for some
1798: * transaction currency code. */

Line 1802: pa_spread_curves_b sp,

1798: * transaction currency code. */
1799: CURSOR multi_bl_fixed_date_ra_cur IS
1800: SELECT DISTINCT(bl.resource_assignment_id)
1801: FROM pa_resource_assignments ra,
1802: pa_spread_curves_b sp,
1803: pa_budget_lines bl
1804: WHERE ra.budget_version_id = p_budget_version_id
1805: AND sp.spread_curve_id = ra.spread_curve_id
1806: AND sp.spread_curve_code = lc_FixedDate

Line 1821: pa_spread_curves_b sp,

1817: * processing required by this cursor. */
1818: CURSOR one_bl_fixed_date_ra_cur IS
1819: SELECT DISTINCT(bl.resource_assignment_id)
1820: FROM pa_resource_assignments ra,
1821: pa_spread_curves_b sp,
1822: pa_budget_lines bl
1823: WHERE ra.budget_version_id = p_budget_version_id
1824: AND sp.spread_curve_id = ra.spread_curve_id
1825: AND sp.spread_curve_code = lc_FixedDate

Line 1838: l_fixed_date_id PA_SPREAD_CURVES_B.SPREAD_CURVE_ID%TYPE;

1834: l_data VARCHAR2(1000);
1835: l_msg_data VARCHAR2(1000);
1836: l_msg_index_out NUMBER;
1837:
1838: l_fixed_date_id PA_SPREAD_CURVES_B.SPREAD_CURVE_ID%TYPE;
1839:
1840: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1841: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1842: l_sysdate DATE := SYSDATE;

Line 1860: FROM pa_spread_curves_b

1856: END IF;
1857:
1858: /* Get the spread curve id for Fixed Date */
1859: SELECT spread_curve_id INTO l_fixed_date_id
1860: FROM pa_spread_curves_b
1861: WHERE spread_curve_code = lc_FixedDate;
1862:
1863: /* Fetch resource assignment id's for resource assignments having
1864: * a fixed date spread curve and multiple budget lines for some