DBA Data[Home] [Help]

APPS.PON_CONTERMS_UTL_GRP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 459: hr_all_organization_units ou

455: l_pon_sys_vars(72).variable_value_id
456: from
457: pon_auction_headers_all pah,
458: pon_bid_headers pbh,
459: hr_all_organization_units ou
460: where
461: pbh.bid_number = p_doc_id and
462: pbh.auction_header_id = pah.auction_header_id and
463: pah.org_id = ou.organization_id(+) and

Line 714: hr_all_organization_units ou

710: -- ECO 4241852
711: l_pon_sys_vars(73).variable_value_id
712: from
713: pon_auction_headers_all pah,
714: hr_all_organization_units ou
715: where
716: pah.auction_header_id = p_doc_id and
717: pah.org_id = ou.organization_id(+) and
718: nvl(ou.date_from(+),sysdate-1) < sysdate and

Line 1083: hr_all_organization_units ou1,

1079: l_pon_sys_vars(43)
1080: from
1081: pon_auction_headers_all pah1,
1082: pon_auction_headers_all pah2,
1083: hr_all_organization_units ou1,
1084: hr_all_organization_units ou2
1085: where
1086: pah1.auction_header_id = p_doc_id and
1087: pah1.org_id = ou1.organization_id(+) and

Line 1084: hr_all_organization_units ou2

1080: from
1081: pon_auction_headers_all pah1,
1082: pon_auction_headers_all pah2,
1083: hr_all_organization_units ou1,
1084: hr_all_organization_units ou2
1085: where
1086: pah1.auction_header_id = p_doc_id and
1087: pah1.org_id = ou1.organization_id(+) and
1088: nvl(ou1.date_from(+),sysdate-1) < sysdate and