APPS.JTF_RS_CONC_RES_PUB dependencies on HR_OPERATING_UNITS

Line 491: from hr_operating_units

487:
488: -- Added the below cursor to validate the operating unit belongs to the current business_group_id
489: CURSOR op_units_cur(c_business_group_id number, c_org_id number) IS
490: select organization_id
491: from hr_operating_units
492: where business_group_id = c_business_group_id
493: and organization_id = c_org_id;
494:
495: l_organization_id number;

Line 3611: -- HR_OPERATING_UNITS ORG

3607: POC.LAST_NAME LAST_NAME
3608: FROM PO_VENDOR_CONTACTS POC,
3609: PO_VENDOR_SITES_ALL POS,
3610: PO_VENDORS POV
3611: -- HR_OPERATING_UNITS ORG
3612: WHERE POC.VENDOR_CONTACT_ID = l_supplier_contact_id
3613: AND POC.VENDOR_SITE_ID = POS.VENDOR_SITE_ID
3614: AND POS.VENDOR_ID = POV.VENDOR_ID;
3615: -- AND POS.ORG_ID = ORG.ORGANIZATION_ID;

Line 3622: FROM hr_operating_units

3618:
3619: --Added this Cursor (and some related code changes) as a fix for bug #2586720, single org sync issue
3620: CURSOR c_org_name (l_org_id IN NUMBER) IS
3621: SELECT name
3622: FROM hr_operating_units
3623: WHERE organization_id = l_org_id;
3624:
3625: /* Moved the initial assignment of below variables to inside begin */
3626: l_sysdate DATE;

Line 3630: l_org_name HR_OPERATING_UNITS.NAME%TYPE := NULL;

3626: l_sysdate DATE;
3627: l_user_id NUMBER;
3628: l_login NUMBER;
3629:
3630: l_org_name HR_OPERATING_UNITS.NAME%TYPE := NULL;
3631:
3632: begin
3633:
3634: l_sysdate := sysdate;