DBA Data[Home] [Help]

APPS.PON_TEAM_SCORING_UTIL_PVT dependencies on PON_SCORING_TEAM_MEMBERS

Line 380: ,pon_scoring_team_members pstm

376: (SELECT pstm.user_id, paa.sequence_number
377: FROM pon_auction_attributes paa
378: ,pon_auction_sections pas
379: ,pon_scoring_team_sections psts
380: ,pon_scoring_team_members pstm
381: WHERE paa.auction_header_id = pas.auction_header_id
382: AND paa.attr_group_seq_number = pas.attr_group_seq_number
383: AND paa.attribute_list_id = -1
384: AND paa.line_number = -1

Line 404: FROM pon_scoring_team_members pstm

400: AND ptmbs.user_id IN
401: (
402: SELECT -- for all users of this team
403: user_id
404: FROM pon_scoring_team_members pstm
405: WHERE pstm.auction_header_id = ptmbs.auction_header_id
406: AND pstm.team_id = p_team_id
407: )
408: AND NOT EXISTS -- where there is no row for a bid in the child table