DBA Data[Home] [Help]

APPS.PON_WITH_DRAW_PKG dependencies on PON_NOTIF_SUBSCRIPTION_GROUPS

Line 75: PON_NOTIF_SUBSCRIPTION_GROUPS

71: THEN
72:
73: SELECT Nvl(SOL_SUBSCRIPTION_FLAG,'N') INTO L_NOTIF_SUBSCR_FLAG
74: FROM
75: PON_NOTIF_SUBSCRIPTION_GROUPS
76: WHERE
77: NOTIF_GROUP_CODE='S_OFFER_WITH_DRAW'
78: AND
79: NOTIF_GROUP_TYPE='TO_SUPPLIER'

Line 89: PON_NOTIF_SUBSCRIPTION_GROUPS

85: THEN
86:
87: SELECT Nvl(AUCTION_SUBSCRIPTION_FLAG,'N') INTO L_NOTIF_SUBSCR_FLAG
88: FROM
89: PON_NOTIF_SUBSCRIPTION_GROUPS
90: WHERE
91: NOTIF_GROUP_CODE='S_OFFER_WITH_DRAW'
92: AND
93: NOTIF_GROUP_TYPE='TO_SUPPLIER'

Line 102: PON_NOTIF_SUBSCRIPTION_GROUPS

98: THEN
99:
100: SELECT Nvl(RFI_SUBSCRIPTION_FLAG,'N') INTO L_NOTIF_SUBSCR_FLAG
101: FROM
102: PON_NOTIF_SUBSCRIPTION_GROUPS
103: WHERE
104: NOTIF_GROUP_CODE='S_OFFER_WITH_DRAW'
105: AND
106: NOTIF_GROUP_TYPE='TO_SUPPLIER'

Line 115: PON_NOTIF_SUBSCRIPTION_GROUPS

111: THEN
112:
113: SELECT Nvl(RFQ_SUBSCRIPTION_FLAG,'N') INTO L_NOTIF_SUBSCR_FLAG
114: FROM
115: PON_NOTIF_SUBSCRIPTION_GROUPS
116: WHERE
117: NOTIF_GROUP_CODE='S_OFFER_WITH_DRAW'
118: AND
119: NOTIF_GROUP_TYPE='TO_SUPPLIER'

Line 481: PON_NOTIF_SUBSCRIPTION_GROUPS

477: THEN
478:
479: SELECT Nvl(SOL_SUBSCRIPTION_FLAG,'N') INTO L_NOTIF_SUBSCR_FLAG
480: FROM
481: PON_NOTIF_SUBSCRIPTION_GROUPS
482: WHERE
483: NOTIF_GROUP_CODE='B_OFFER_WITH_DRAW'
484: AND
485: NOTIF_GROUP_TYPE='TO_BUYER'

Line 495: PON_NOTIF_SUBSCRIPTION_GROUPS

491: THEN
492:
493: SELECT Nvl(AUCTION_SUBSCRIPTION_FLAG,'N') INTO L_NOTIF_SUBSCR_FLAG
494: FROM
495: PON_NOTIF_SUBSCRIPTION_GROUPS
496: WHERE
497: NOTIF_GROUP_CODE='B_OFFER_WITH_DRAW'
498: AND
499: NOTIF_GROUP_TYPE='TO_BUYER'

Line 508: PON_NOTIF_SUBSCRIPTION_GROUPS

504: THEN
505:
506: SELECT Nvl(RFI_SUBSCRIPTION_FLAG,'N') INTO L_NOTIF_SUBSCR_FLAG
507: FROM
508: PON_NOTIF_SUBSCRIPTION_GROUPS
509: WHERE
510: NOTIF_GROUP_CODE='B_OFFER_WITH_DRAW'
511: AND
512: NOTIF_GROUP_TYPE='TO_BUYER'

Line 521: PON_NOTIF_SUBSCRIPTION_GROUPS

517: THEN
518:
519: SELECT Nvl(RFQ_SUBSCRIPTION_FLAG,'N') INTO L_NOTIF_SUBSCR_FLAG
520: FROM
521: PON_NOTIF_SUBSCRIPTION_GROUPS
522: WHERE
523: NOTIF_GROUP_CODE='B_OFFER_WITH_DRAW'
524: AND
525: NOTIF_GROUP_TYPE='TO_BUYER'