DBA Data[Home] [Help]

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 3610: ,pon_scoring_team_members stmem

3606: stmem.team_id
3607: ,stmem.user_id
3608: ,per.full_name member_name
3609: FROM pon_auction_headers_all pah
3610: ,pon_scoring_team_members stmem
3611: ,fnd_user fuser
3612: ,per_all_people_f per
3613: WHERE pah.auction_header_id = p_auction_header_id
3614: AND stmem.auction_header_id = pah.auction_header_id

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

3859: and (l_is_section_restricted = 'N'
3860: or l_is_section_restricted = 'Y'
3861: and paa.attr_group_seq_number in (
3862: select pas.attr_group_seq_number
3863: from pon_scoring_team_members pstm, pon_scoring_team_sections psts, pon_auction_sections pas
3864: where pstm.auction_header_id = p_auction_header_id
3865: and pstm.user_id = p_user_id
3866: and psts.auction_header_id = pstm.auction_header_id
3867: and psts.team_id = pstm.team_id