DBA Data[Home] [Help]

APPS.OKS_OMINT_PUB dependencies on OKS_SERV_AVAIL_EXCEPTS_V

Line 365: From OKS_SERV_AVAIL_EXCEPTS_V

361: Cursor l_product_csr (p_mast_id Number, p_prod_id Number) Is
362: Select Object1_Id1,
363: Start_Date_Active,
364: End_Date_Active
365: From OKS_SERV_AVAIL_EXCEPTS_V
366: Where SAV_Id = p_mast_id And
367: Object1_Id1 = p_prod_id;
368:
369:

Line 448: From OKS_SERV_AVAIL_EXCEPTS_V

444: Cursor l_customer_csr (p_mast_id Number, p_cust_id Number) Is
445: Select Object1_Id1,
446: Start_Date_Active,
447: End_Date_Active
448: From OKS_SERV_AVAIL_EXCEPTS_V
449: Where SAV_Id = p_mast_id
450: And Object1_Id1 = p_cust_id;
451:
452: BEGIN

Line 1155: From OKS_SERV_AVAIL_EXCEPTS_V

1151: Cursor l_customer_csr (p_mast_id Number, p_party_id Number) Is
1152: Select Object1_Id1,
1153: Start_Date_Active,
1154: End_Date_Active
1155: From OKS_SERV_AVAIL_EXCEPTS_V
1156: Where SAV_Id = p_mast_id
1157: And Object1_Id1 = p_party_id;
1158:
1159: