DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PON_AUCTION_SECTIONS

Line 1828: ,pon_auction_sections sections

1824: ,sections.section_name
1825: ,team_sections.auction_header_id
1826: ,team_sections.team_id
1827: FROM pon_scoring_team_sections team_sections
1828: ,pon_auction_sections sections
1829: WHERE team_sections.auction_header_id = pah.auction_header_id
1830: AND sections.section_id = team_sections.section_id
1831: AND sections.auction_header_id = team_sections.auction_header_id
1832: AND pah.has_scoring_teams_flag = 'Y' -- sections present only if teams present

Line 1947: pon_auction_attributes paa,pon_auction_sections pass

1943: and pa.attr_level='HEADER'
1944: and (l_is_buyer_negpdf = 'Y' or pa.internal_attr_flag <> 'Y')
1945: order by pa.attr_disp_seq_number) as HEADER_ATTRIBUTES_DETAILS
1946: from
1947: pon_auction_attributes paa,pon_auction_sections pass
1948: where
1949: pass.auction_header_id = pah.auction_header_id
1950: and pass.auction_header_id = paa.auction_header_id(+)
1951: and pass.section_name = paa.section_name(+)

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