DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PON_SCORING_TEAMS

Line 729: pon_scoring_teams pst

725: BEGIN
726: SELECT pst.price_visible_flag
727: INTO l_is_price_visible
728: FROM pon_scoring_team_members pstm,
729: pon_scoring_teams pst
730: WHERE pstm.auction_header_id = p_auction_header_id
731: AND pstm.user_id = p_user_id
732: AND pst.auction_header_id = pstm.auction_header_id
733: AND pstm.team_id = pst.team_id;

Line 3580: pon_scoring_teams sctm

3576: ,sctm.team_name
3577: ,sctm.price_visible_flag
3578: ,sctm.instruction_text
3579: FROM pon_auction_headers_all pah,
3580: pon_scoring_teams sctm
3581: WHERE pah.auction_header_id = p_auction_header_id
3582: AND sctm.auction_header_id = pah.auction_header_id
3583: AND pah.has_scoring_teams_flag = 'Y' -- teams present only if flag present
3584: ORDER BY sctm.team_name;