APPS.JTF_RS_CONC_RES_PUB dependencies on HR_OPERATING_UNITS

Line 549: from hr_operating_units

545:
546: -- Added the below cursor to validate the operating unit belongs to the current business_group_id
547: CURSOR op_units_cur(c_business_group_id number, c_org_id number) IS
548: select organization_id
549: from hr_operating_units
550: where business_group_id = c_business_group_id
551: and organization_id = c_org_id;
552:
553: l_organization_id number;

Line 4060: -- HR_OPERATING_UNITS ORG

4056: POC.LAST_NAME LAST_NAME
4057: FROM PO_VENDOR_CONTACTS POC,
4058: PO_VENDOR_SITES_ALL POS,
4059: PO_VENDORS POV
4060: -- HR_OPERATING_UNITS ORG
4061: WHERE POC.VENDOR_CONTACT_ID = l_supplier_contact_id
4062: AND POC.VENDOR_SITE_ID = POS.VENDOR_SITE_ID
4063: AND POS.VENDOR_ID = POV.VENDOR_ID;
4064: -- AND POS.ORG_ID = ORG.ORGANIZATION_ID;

Line 4071: FROM hr_operating_units

4067:
4068: --Added this Cursor (and some related code changes) as a fix for bug #2586720, single org sync issue
4069: CURSOR c_org_name (l_org_id IN NUMBER) IS
4070: SELECT name
4071: FROM hr_operating_units
4072: WHERE organization_id = l_org_id;
4073:
4074: /* Moved the initial assignment of below variables to inside begin */
4075: l_sysdate DATE;

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

4075: l_sysdate DATE;
4076: l_user_id NUMBER;
4077: l_login NUMBER;
4078:
4079: l_org_name HR_OPERATING_UNITS.NAME%TYPE := NULL;
4080:
4081: begin
4082:
4083: l_sysdate := sysdate;