APPS.PON_NEGOTIATION_COPY_GRP dependencies on HZ_RELATIONSHIPS

Line 7195: HZ_RELATIONSHIPS HZR

7191: SELECT
7192: DISTINCT PBP.trading_partner_contact_id BULK COLLECT
7193: INTO l_inactive_supplier_contacts
7194: FROM PON_BIDDING_PARTIES PBP,
7195: HZ_RELATIONSHIPS HZR
7196: WHERE PBP.AUCTION_HEADER_ID = p_auction_header_id
7197: AND HZR.SUBJECT_ID = PBP.TRADING_PARTNER_CONTACT_ID
7198: AND HZR.OBJECT_ID = PBP.TRADING_PARTNER_ID
7199: AND HZR.RELATIONSHIP_CODE = 'CONTACT_OF'

Line 11841: FROM FND_USER, HZ_RELATIONSHIPS

11837: --
11838: BEGIN
11839: SELECT FND_USER.EMPLOYEE_ID
11840: INTO l_auc_contact_id
11841: FROM FND_USER, HZ_RELATIONSHIPS
11842: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
11843: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
11844: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
11845: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'

Line 11843: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id

11839: SELECT FND_USER.EMPLOYEE_ID
11840: INTO l_auc_contact_id
11841: FROM FND_USER, HZ_RELATIONSHIPS
11842: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
11843: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
11844: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
11845: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
11846: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
11847: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE

Line 11844: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID

11840: INTO l_auc_contact_id
11841: FROM FND_USER, HZ_RELATIONSHIPS
11842: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
11843: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
11844: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
11845: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
11846: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
11847: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
11848: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE;

Line 11845: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'

11841: FROM FND_USER, HZ_RELATIONSHIPS
11842: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
11843: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
11844: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
11845: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
11846: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
11847: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
11848: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE;
11849: EXCEPTION

Line 11846: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'

11842: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
11843: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
11844: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
11845: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
11846: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
11847: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
11848: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE;
11849: EXCEPTION
11850: WHEN OTHERS THEN

Line 11847: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE

11843: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
11844: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
11845: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
11846: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
11847: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
11848: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE;
11849: EXCEPTION
11850: WHEN OTHERS THEN
11851: l_auc_contact_id := NULL;

Line 11848: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE;

11844: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
11845: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
11846: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
11847: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
11848: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE;
11849: EXCEPTION
11850: WHEN OTHERS THEN
11851: l_auc_contact_id := NULL;
11852: -- Log Error