APPS.PA_FP_GEN_PUB dependencies on PA_SPREAD_CURVES_B

Line 1361: FROM pa_spread_curves_b

1357: VALUES ( l_ins_ra_id_tab(i) );
1358:
1359: SELECT spread_curve_id
1360: INTO l_fixed_date_curve_id
1361: FROM pa_spread_curves_b
1362: WHERE spread_curve_code = lc_fixed_date_code;
1363:
1364: -- SQL Repository Bug 4884824; SQL ID 14902330
1365: -- Fixed Full Index Scan violation by replacing

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

1803: IS
1804: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_GEN_PUB.MAINTAIN_FIXED_DATE_SP';
1805:
1806: /* String constant for the fixed date spread curve code */
1807: lc_FixedDate CONSTANT PA_SPREAD_CURVES_B.SPREAD_CURVE_CODE%TYPE := 'FIXED_DATE';
1808:
1809: /* This cursor picks up resource assignment id's for resource assignments
1810: * having a fixed date spread curve and at least two budget lines for some
1811: * transaction currency code. */

Line 1815: pa_spread_curves_b sp,

1811: * transaction currency code. */
1812: CURSOR multi_bl_fixed_date_ra_cur IS
1813: SELECT DISTINCT(bl.resource_assignment_id)
1814: FROM pa_resource_assignments ra,
1815: pa_spread_curves_b sp,
1816: pa_budget_lines bl
1817: WHERE ra.budget_version_id = p_budget_version_id
1818: AND sp.spread_curve_id = ra.spread_curve_id
1819: AND sp.spread_curve_code = lc_FixedDate

Line 1834: pa_spread_curves_b sp,

1830: * processing required by this cursor. */
1831: CURSOR one_bl_fixed_date_ra_cur IS
1832: SELECT DISTINCT(bl.resource_assignment_id)
1833: FROM pa_resource_assignments ra,
1834: pa_spread_curves_b sp,
1835: pa_budget_lines bl
1836: WHERE ra.budget_version_id = p_budget_version_id
1837: AND sp.spread_curve_id = ra.spread_curve_id
1838: AND sp.spread_curve_code = lc_FixedDate

Line 1851: l_fixed_date_id PA_SPREAD_CURVES_B.SPREAD_CURVE_ID%TYPE;

1847: l_data VARCHAR2(1000);
1848: l_msg_data VARCHAR2(1000);
1849: l_msg_index_out NUMBER;
1850:
1851: l_fixed_date_id PA_SPREAD_CURVES_B.SPREAD_CURVE_ID%TYPE;
1852:
1853: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1854: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1855: l_sysdate DATE := SYSDATE;

Line 1873: FROM pa_spread_curves_b

1869: END IF;
1870:
1871: /* Get the spread curve id for Fixed Date */
1872: SELECT spread_curve_id INTO l_fixed_date_id
1873: FROM pa_spread_curves_b
1874: WHERE spread_curve_code = lc_FixedDate;
1875:
1876: /* Fetch resource assignment id's for resource assignments having
1877: * a fixed date spread curve and multiple budget lines for some