APPS.PON_PRINTING_PKG dependencies on PON_SCORING_TEAM_MEMBERS

Line 728: FROM pon_scoring_team_members pstm,

724: if (l_is_scorer = 'Y') then
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

Line 1812: FROM pon_scoring_team_members stmem

1808: -- multipler user ids resulting in more rows being returned
1809: stmem.team_id
1810: ,stmem.user_id
1811: ,per.full_name member_name
1812: FROM pon_scoring_team_members stmem
1813: ,fnd_user fuser
1814: ,per_all_people_f per
1815: WHERE stmem.auction_header_id = pah.auction_header_id
1816: AND stmem.user_id = fuser.user_id

Line 1959: from pon_scoring_team_members pstm, pon_scoring_team_sections psts, pon_auction_sections pas

1955: and (l_is_section_restricted = 'N'
1956: or l_is_section_restricted = 'Y'
1957: and paa.attr_group_seq_number in (
1958: select pas.attr_group_seq_number
1959: from pon_scoring_team_members pstm, pon_scoring_team_sections psts, pon_auction_sections pas
1960: where pstm.auction_header_id = pah.auction_header_id
1961: and pstm.user_id = p_user_id
1962: and psts.auction_header_id = pstm.auction_header_id
1963: and psts.team_id = pstm.team_id