eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_PRINTING_PKG dependencies on HR_GENERAL

Line 2620: and nvl(loc_bill.business_group_id(+), nvl(hr_general.get_business_group_id, -99))

2616: and bill_territories_tl.territory_code(+) = loc_bill.country
2617: and bill_territories_tl.language(+) = l_printing_language
2618: and loc_bill.bill_to_site_flag(+)='Y'
2619: and sysdate < nvl(loc_bill.inactive_date(+), sysdate + 1)
2620: and nvl(loc_bill.business_group_id(+), nvl(hr_general.get_business_group_id, -99))
2621: = nvl(hr_general.get_business_group_id, nvl(loc_bill.business_group_id(+), -99))
2622: and loc_ship.location_id(+) = pah.ship_to_location_id
2623: and ship_territories_tl.territory_code(+) = loc_ship.country
2624: and ship_territories_tl.language(+) = l_printing_language

Line 2621: = nvl(hr_general.get_business_group_id, nvl(loc_bill.business_group_id(+), -99))

2617: and bill_territories_tl.language(+) = l_printing_language
2618: and loc_bill.bill_to_site_flag(+)='Y'
2619: and sysdate < nvl(loc_bill.inactive_date(+), sysdate + 1)
2620: and nvl(loc_bill.business_group_id(+), nvl(hr_general.get_business_group_id, -99))
2621: = nvl(hr_general.get_business_group_id, nvl(loc_bill.business_group_id(+), -99))
2622: and loc_ship.location_id(+) = pah.ship_to_location_id
2623: and ship_territories_tl.territory_code(+) = loc_ship.country
2624: and ship_territories_tl.language(+) = l_printing_language
2625: and loc_ship.ship_to_site_flag(+)='Y'

Line 2627: and nvl(loc_ship.business_group_id(+), nvl(hr_general.get_business_group_id, -99))

2623: and ship_territories_tl.territory_code(+) = loc_ship.country
2624: and ship_territories_tl.language(+) = l_printing_language
2625: and loc_ship.ship_to_site_flag(+)='Y'
2626: and sysdate < nvl(loc_ship.inactive_date(+), sysdate + 1)
2627: and nvl(loc_ship.business_group_id(+), nvl(hr_general.get_business_group_id, -99))
2628: = nvl(hr_general.get_business_group_id, nvl(loc_ship.business_group_id(+), -99))
2629: and pah.org_id = ou.organization_id(+)
2630: and nvl(ou.date_from(+),sysdate-1) < sysdate
2631: and nvl(ou.date_to(+),sysdate+1) > sysdate

Line 2628: = nvl(hr_general.get_business_group_id, nvl(loc_ship.business_group_id(+), -99))

2624: and ship_territories_tl.language(+) = l_printing_language
2625: and loc_ship.ship_to_site_flag(+)='Y'
2626: and sysdate < nvl(loc_ship.inactive_date(+), sysdate + 1)
2627: and nvl(loc_ship.business_group_id(+), nvl(hr_general.get_business_group_id, -99))
2628: = nvl(hr_general.get_business_group_id, nvl(loc_ship.business_group_id(+), -99))
2629: and pah.org_id = ou.organization_id(+)
2630: and nvl(ou.date_from(+),sysdate-1) < sysdate
2631: and nvl(ou.date_to(+),sysdate+1) > sysdate
2632: --bug 7592494

Line 2869: and nvl(hl.business_group_id(+), nvl(hr_general.get_business_group_id, -99))

2865: and paip.ip_category_id = icx.rt_category_id(+)
2866: and icx.language(+) = l_printing_language
2867: and lt.line_type_id(+) = paip.line_type_id
2868: and lt.language(+) = l_printing_language
2869: and nvl(hl.business_group_id(+), nvl(hr_general.get_business_group_id, -99))
2870: = nvl(hr_general.get_business_group_id, nvl(hl.business_group_id(+), -99))
2871: and (l_is_buyer_negpdf IN (SELECT 'Y' FROM dual)
2872: or
2873: (not exists (select 'x'

Line 2870: = nvl(hr_general.get_business_group_id, nvl(hl.business_group_id(+), -99))

2866: and icx.language(+) = l_printing_language
2867: and lt.line_type_id(+) = paip.line_type_id
2868: and lt.language(+) = l_printing_language
2869: and nvl(hl.business_group_id(+), nvl(hr_general.get_business_group_id, -99))
2870: = nvl(hr_general.get_business_group_id, nvl(hl.business_group_id(+), -99))
2871: and (l_is_buyer_negpdf IN (SELECT 'Y' FROM dual)
2872: or
2873: (not exists (select 'x'
2874: from pon_bidding_parties bp

Line 4125: and nvl(loc.business_group_id, nvl(hr_general.get_business_group_id, -99))

4121: and sysdate < nvl(loc.inactive_date, sysdate + 1)
4122: and loc.location_id = pas.ship_to_location_id
4123: and ship_territories_tl.territory_code(+) = loc.country
4124: and ship_territories_tl.language(+) = l_printing_language
4125: and nvl(loc.business_group_id, nvl(hr_general.get_business_group_id, -99))
4126: = nvl(hr_general.get_business_group_id, nvl(loc.business_group_id, -99))
4127: union
4128: (select
4129: mp.organization_id id,

Line 4126: = nvl(hr_general.get_business_group_id, nvl(loc.business_group_id, -99))

4122: and loc.location_id = pas.ship_to_location_id
4123: and ship_territories_tl.territory_code(+) = loc.country
4124: and ship_territories_tl.language(+) = l_printing_language
4125: and nvl(loc.business_group_id, nvl(hr_general.get_business_group_id, -99))
4126: = nvl(hr_general.get_business_group_id, nvl(loc.business_group_id, -99))
4127: union
4128: (select
4129: mp.organization_id id,
4130: mp.organization_code name,