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 1723: and nvl(hl.business_group_id(+), nvl(hr_general.get_business_group_id, -99))

1719: and paip.ip_category_id = icx.rt_category_id(+)
1720: and icx.language(+) = l_printing_language
1721: and lt.line_type_id(+) = paip.line_type_id
1722: and lt.language(+) = l_printing_language
1723: and nvl(hl.business_group_id(+), nvl(hr_general.get_business_group_id, -99))
1724: = nvl(hr_general.get_business_group_id, nvl(hl.business_group_id(+), -99))
1725: and (l_is_buyer_negpdf = 'Y'
1726: or
1727: (not exists (select 'x'

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

1720: and icx.language(+) = l_printing_language
1721: and lt.line_type_id(+) = paip.line_type_id
1722: and lt.language(+) = l_printing_language
1723: and nvl(hl.business_group_id(+), nvl(hr_general.get_business_group_id, -99))
1724: = nvl(hr_general.get_business_group_id, nvl(hl.business_group_id(+), -99))
1725: and (l_is_buyer_negpdf = 'Y'
1726: or
1727: (not exists (select 'x'
1728: from pon_bidding_parties bp

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

2535: and sysdate < nvl(loc.inactive_date, sysdate + 1)
2536: and loc.location_id = pas.ship_to_location_id
2537: and ship_territories_tl.territory_code(+) = loc.country
2538: and ship_territories_tl.language(+) = l_printing_language
2539: and nvl(loc.business_group_id, nvl(hr_general.get_business_group_id, -99))
2540: = nvl(hr_general.get_business_group_id, nvl(loc.business_group_id, -99)))
2541: union
2542: (select
2543: mp.organization_id id,

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

2536: and loc.location_id = pas.ship_to_location_id
2537: and ship_territories_tl.territory_code(+) = loc.country
2538: and ship_territories_tl.language(+) = l_printing_language
2539: and nvl(loc.business_group_id, nvl(hr_general.get_business_group_id, -99))
2540: = nvl(hr_general.get_business_group_id, nvl(loc.business_group_id, -99)))
2541: union
2542: (select
2543: mp.organization_id id,
2544: mp.organization_code name,

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

3195: and bill_territories_tl.territory_code(+) = loc_bill.country
3196: and bill_territories_tl.language(+) = l_printing_language
3197: and loc_bill.bill_to_site_flag(+)='Y'
3198: and sysdate < nvl(loc_bill.inactive_date(+), sysdate + 1)
3199: and nvl(loc_bill.business_group_id(+), nvl(hr_general.get_business_group_id, -99))
3200: = nvl(hr_general.get_business_group_id, nvl(loc_bill.business_group_id(+), -99))
3201: and loc_ship.location_id(+) = pah.ship_to_location_id
3202: and ship_territories_tl.territory_code(+) = loc_ship.country
3203: and ship_territories_tl.language(+) = l_printing_language

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

3196: and bill_territories_tl.language(+) = l_printing_language
3197: and loc_bill.bill_to_site_flag(+)='Y'
3198: and sysdate < nvl(loc_bill.inactive_date(+), sysdate + 1)
3199: and nvl(loc_bill.business_group_id(+), nvl(hr_general.get_business_group_id, -99))
3200: = nvl(hr_general.get_business_group_id, nvl(loc_bill.business_group_id(+), -99))
3201: and loc_ship.location_id(+) = pah.ship_to_location_id
3202: and ship_territories_tl.territory_code(+) = loc_ship.country
3203: and ship_territories_tl.language(+) = l_printing_language
3204: and loc_ship.ship_to_site_flag(+)='Y'

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

3202: and ship_territories_tl.territory_code(+) = loc_ship.country
3203: and ship_territories_tl.language(+) = l_printing_language
3204: and loc_ship.ship_to_site_flag(+)='Y'
3205: and sysdate < nvl(loc_ship.inactive_date(+), sysdate + 1)
3206: and nvl(loc_ship.business_group_id(+), nvl(hr_general.get_business_group_id, -99))
3207: = nvl(hr_general.get_business_group_id, nvl(loc_ship.business_group_id(+), -99))
3208: and pah.org_id = ou.organization_id(+)
3209: and nvl(ou.date_from(+),sysdate-1) < sysdate
3210: and nvl(ou.date_to(+),sysdate+1) > sysdate

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

3203: and ship_territories_tl.language(+) = l_printing_language
3204: and loc_ship.ship_to_site_flag(+)='Y'
3205: and sysdate < nvl(loc_ship.inactive_date(+), sysdate + 1)
3206: and nvl(loc_ship.business_group_id(+), nvl(hr_general.get_business_group_id, -99))
3207: = nvl(hr_general.get_business_group_id, nvl(loc_ship.business_group_id(+), -99))
3208: and pah.org_id = ou.organization_id(+)
3209: and nvl(ou.date_from(+),sysdate-1) < sysdate
3210: and nvl(ou.date_to(+),sysdate+1) > sysdate
3211: and pon_conterms_utl_pvt.get_legal_entity_id(pah.org_id) = entity.organization_id(+)