APPS.PA_CI_SUPPLIER_UTILS dependencies on PA_CONTROL_ITEMS

Line 1379: ,PA_CONTROL_ITEMS ci

1375: ,NVL(FND_GLOBAL.login_id,-99)
1376: ,sysdate
1377: ,NVL(FND_GLOBAL.login_id,-99)
1378: FROM PA_CI_SUPPLIER_DETAILS si
1379: ,PA_CONTROL_ITEMS ci
1380: WHERE si.CI_ID = p_from_ci_item_id
1381: AND ci.ci_id = p_to_ci_item_id;
1382:
1383: IF l_debug_mode = 'Y' THEN

Line 1618: FROM pa_control_items

1614:
1615: CURSOR cur(p_ci_id number) is
1616: SELECT
1617: decode (NVL(original_ci_id,0),0,ci_id, original_ci_id)
1618: FROM pa_control_items
1619: WHERE ci_id = p_ci_id;
1620:
1621: l_ci_id number;
1622: original_ci_id number;

Line 1763: from pa_control_items

1759:
1760:
1761: cursor get_project_id is
1762: select project_id
1763: from pa_control_items
1764: where ci_id = p_ci_id;
1765:
1766: l_project_id number;
1767:

Line 1970: from pa_control_items

1966: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1967:
1968: cursor get_project_id is
1969: select project_id
1970: from pa_control_items
1971: where ci_id = p_ci_id;
1972:
1973: l_project_id number;
1974:

Line 1983: from pa_ci_types_b typ, pa_control_items items

1979: l_budget_version_id number;
1980:
1981: cursor get_budget_update_method is
1982: Select typ.impact_budget_type_code
1983: from pa_ci_types_b typ, pa_control_items items
1984: where items.ci_type_id=typ.ci_type_id and ci_id = p_ci_id;
1985:
1986: l_budget_update_method varchar2(30);
1987: