DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PON_AUCTION_SECTIONS

Line 3645: ,pon_auction_sections sections

3641: ,team_sections.auction_header_id
3642: ,team_sections.team_id
3643: FROM pon_auction_headers_all pah,
3644: pon_scoring_team_sections team_sections
3645: ,pon_auction_sections sections
3646: WHERE pah.auction_header_id = p_auction_header_id
3647: AND team_sections.auction_header_id = pah.auction_header_id
3648: AND sections.section_id = team_sections.section_id
3649: AND sections.auction_header_id = team_sections.auction_header_id

Line 3851: pon_auction_attributes paa,pon_auction_sections pass

3847: and pa.attr_level='HEADER'
3848: and (l_is_buyer_negpdf = 'Y' or pa.internal_attr_flag <> 'Y')
3849: order by pa.attr_disp_seq_number) as HEADER_ATTRIBUTES_DETAILS
3850: from
3851: pon_auction_attributes paa,pon_auction_sections pass
3852: where
3853: pass.auction_header_id = p_auction_header_id
3854: and pass.auction_header_id = paa.auction_header_id(+)
3855: and pass.section_name = paa.section_name(+)

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