APPS.PA_CI_SUPPLIER_PKG dependencies on DUAL

Line 65: from sys.dual;

61: where ci_transaction_id = x_CI_TRANSACTION_ID;
62:
63: cursor get_itemid is
64: select pa_ci_supplier_details_s.nextval
65: from sys.dual;
66:
67: cursor get_budget_data(bvId number) is
68: select prac.total_projfunc_burdened_cost , prac.total_projfunc_revenue, prac.txn_average_bill_rate
69: from pa_resource_assignments pra, pa_resource_asgn_curr prac

Line 82: from sys.dual;

78: where ci_id = p_ci_id;
79:
80: cursor get_res_asgn_id is
81: select pa_resource_assignments_s.nextval
82: from sys.dual;
83:
84: cursor get_burdened_cost(ci_trans_id number) is
85: select final_cost from pa_ci_supplier_details
86: where ci_transaction_id = ci_trans_id;

Line 963: from sys.dual;

959: where ci_transaction_id = p_ci_transaction_id;
960:
961: cursor get_res_asgn_id is
962: select pa_resource_assignments_s.nextval
963: from sys.dual;
964:
965: CURSOR cur_row is
966: SELECT CI_TYPE_ID
967: ,CI_ID