DBA Data[Home] [Help]

APPS.PON_CONTERMS_UTL_GRP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 441: hr_all_organization_units ou

437: l_pon_sys_vars(72).variable_value_id
438: from
439: pon_auction_headers_all pah,
440: pon_bid_headers pbh,
441: hr_all_organization_units ou
442: where
443: pbh.bid_number = p_doc_id and
444: pbh.auction_header_id = pah.auction_header_id and
445: pah.org_id = ou.organization_id(+) and

Line 694: hr_all_organization_units ou

690: -- ECO 4241852
691: l_pon_sys_vars(73).variable_value_id
692: from
693: pon_auction_headers_all pah,
694: hr_all_organization_units ou
695: where
696: pah.auction_header_id = p_doc_id and
697: pah.org_id = ou.organization_id(+) and
698: nvl(ou.date_from(+),sysdate-1) < sysdate and

Line 1061: hr_all_organization_units ou1,

1057: l_pon_sys_vars(43)
1058: from
1059: pon_auction_headers_all pah1,
1060: pon_auction_headers_all pah2,
1061: hr_all_organization_units ou1,
1062: hr_all_organization_units ou2
1063: where
1064: pah1.auction_header_id = p_doc_id and
1065: pah1.org_id = ou1.organization_id(+) and

Line 1062: hr_all_organization_units ou2

1058: from
1059: pon_auction_headers_all pah1,
1060: pon_auction_headers_all pah2,
1061: hr_all_organization_units ou1,
1062: hr_all_organization_units ou2
1063: where
1064: pah1.auction_header_id = p_doc_id and
1065: pah1.org_id = ou1.organization_id(+) and
1066: nvl(ou1.date_from(+),sysdate-1) < sysdate and