APPS.PA_CONTROL_API_PUB dependencies on PA_CI_SUPPLIER_DETAILS

Line 1425: l_transaction_id pa_ci_supplier_details.ci_transaction_id%type;

1421: -- End: Local Variables.
1422:
1423: l_chk_status_ctrl VARCHAR2(1);
1424: l_ci_id pa_control_items.ci_id%type;
1425: l_transaction_id pa_ci_supplier_details.ci_transaction_id%type;
1426: l_status_code pa_control_items.status_code%type;
1427:
1428: CURSOR Check_Valid_CI_TRANS_ID IS
1429: SELECT ci_transaction_id ,ci_id

Line 1430: FROM pa_ci_supplier_details

1426: l_status_code pa_control_items.status_code%type;
1427:
1428: CURSOR Check_Valid_CI_TRANS_ID IS
1429: SELECT ci_transaction_id ,ci_id
1430: FROM pa_ci_supplier_details
1431: WHERE ci_transaction_id = P_CI_TRANSACTION_ID;
1432:
1433: CURSOR c_get_status(c_ci_id NUMBER) IS
1434: SELECT status_code