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 1801: FROM pon_scoring_teams sctm

1797: SELECT sctm.team_id
1798: ,sctm.team_name
1799: ,sctm.price_visible_flag
1800: ,sctm.instruction_text
1801: FROM pon_scoring_teams sctm
1802: WHERE sctm.auction_header_id = pah.auction_header_id
1803: AND pah.has_scoring_teams_flag = 'Y' -- teams present only if flag present
1804: ORDER BY sctm.team_name
1805: ) AS SCORING_TEAMS,