APPS.PON_NEGOTIATION_COPY_GRP dependencies on HZ_RELATIONSHIPS

Line 6049: HZ_RELATIONSHIPS HZR

6045: SELECT
6046: DISTINCT PBP.trading_partner_contact_id BULK COLLECT
6047: INTO l_inactive_supplier_contacts
6048: FROM PON_BIDDING_PARTIES PBP,
6049: HZ_RELATIONSHIPS HZR
6050: WHERE PBP.AUCTION_HEADER_ID = p_auction_header_id
6051: AND HZR.SUBJECT_ID = PBP.TRADING_PARTNER_CONTACT_ID
6052: AND HZR.OBJECT_ID = PBP.TRADING_PARTNER_ID
6053: AND HZR.RELATIONSHIP_CODE = 'CONTACT_OF'

Line 10488: FROM FND_USER, HZ_RELATIONSHIPS

10484: --
10485: BEGIN
10486: SELECT FND_USER.EMPLOYEE_ID
10487: INTO l_auc_contact_id
10488: FROM FND_USER, HZ_RELATIONSHIPS
10489: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
10490: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
10491: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
10492: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'

Line 10490: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id

10486: SELECT FND_USER.EMPLOYEE_ID
10487: INTO l_auc_contact_id
10488: FROM FND_USER, HZ_RELATIONSHIPS
10489: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
10490: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
10491: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
10492: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
10493: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
10494: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE

Line 10491: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID

10487: INTO l_auc_contact_id
10488: FROM FND_USER, HZ_RELATIONSHIPS
10489: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
10490: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
10491: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
10492: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
10493: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
10494: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
10495: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE;

Line 10492: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'

10488: FROM FND_USER, HZ_RELATIONSHIPS
10489: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
10490: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
10491: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
10492: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
10493: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
10494: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
10495: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE;
10496: EXCEPTION

Line 10493: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'

10489: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
10490: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
10491: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
10492: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
10493: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
10494: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
10495: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE;
10496: EXCEPTION
10497: WHEN OTHERS THEN

Line 10494: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE

10490: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
10491: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
10492: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
10493: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
10494: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
10495: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE;
10496: EXCEPTION
10497: WHEN OTHERS THEN
10498: l_auc_contact_id := NULL;

Line 10495: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE;

10491: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
10492: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
10493: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
10494: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
10495: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE;
10496: EXCEPTION
10497: WHEN OTHERS THEN
10498: l_auc_contact_id := NULL;
10499: -- Log Error