DBA Data[Home] [Help]

APPS.PON_OA_UTIL_PKG dependencies on PON_SCORING_TEAMS

Line 183: FROM pon_scoring_teams pst,

179: l_doc_type PON_AUC_DOCTYPES.internal_name%TYPE;
180:
181: CURSOR c_price_visibility (p_cur_auction_header_id NUMBER) IS
182: SELECT pst.team_id
183: FROM pon_scoring_teams pst,
184: pon_scoring_team_members pstm
185: WHERE pst.auction_header_id = pstm.auction_header_id
186: AND pst.team_id = pstm.team_id
187: AND pst.price_visible_flag = 'Y'

Line 191: l_team_id pon_scoring_teams.team_id%TYPE;

187: AND pst.price_visible_flag = 'Y'
188: AND pstm.auction_header_id = p_cur_auction_header_id
189: AND pstm.user_id = FND_GLOBAL.user_id;
190:
191: l_team_id pon_scoring_teams.team_id%TYPE;
192: l_menu_name pon_neg_team_members.menu_name%TYPE;
193:
194: BEGIN
195: