APPS.PON_SOURCING_OPENAPI_GRP dependencies on HZ_RELATIONSHIPS

Line 515: hz_relationships

511: select fnd_user.employee_id
512: into v_auc_contact_id
513: from
514: fnd_user,
515: hz_relationships
516: where
517: fnd_user.user_id = fnd_global.user_id()
518: and hz_relationships.object_id = v_site_id
519: and hz_relationships.subject_id = fnd_user.person_party_id

Line 518: and hz_relationships.object_id = v_site_id

514: fnd_user,
515: hz_relationships
516: where
517: fnd_user.user_id = fnd_global.user_id()
518: and hz_relationships.object_id = v_site_id
519: and hz_relationships.subject_id = fnd_user.person_party_id
520: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
521: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
522: and hz_relationships.start_date <= SYSDATE

Line 519: and hz_relationships.subject_id = fnd_user.person_party_id

515: hz_relationships
516: where
517: fnd_user.user_id = fnd_global.user_id()
518: and hz_relationships.object_id = v_site_id
519: and hz_relationships.subject_id = fnd_user.person_party_id
520: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
521: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
522: and hz_relationships.start_date <= SYSDATE
523: and hz_relationships.end_date >= SYSDATE

Line 520: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'

516: where
517: fnd_user.user_id = fnd_global.user_id()
518: and hz_relationships.object_id = v_site_id
519: and hz_relationships.subject_id = fnd_user.person_party_id
520: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
521: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
522: and hz_relationships.start_date <= SYSDATE
523: and hz_relationships.end_date >= SYSDATE
524: and nvl(fnd_user.end_date,sysdate) >= sysdate;

Line 521: and hz_relationships.relationship_code = 'EMPLOYEE_OF'

517: fnd_user.user_id = fnd_global.user_id()
518: and hz_relationships.object_id = v_site_id
519: and hz_relationships.subject_id = fnd_user.person_party_id
520: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
521: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
522: and hz_relationships.start_date <= SYSDATE
523: and hz_relationships.end_date >= SYSDATE
524: and nvl(fnd_user.end_date,sysdate) >= sysdate;
525: exception

Line 522: and hz_relationships.start_date <= SYSDATE

518: and hz_relationships.object_id = v_site_id
519: and hz_relationships.subject_id = fnd_user.person_party_id
520: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
521: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
522: and hz_relationships.start_date <= SYSDATE
523: and hz_relationships.end_date >= SYSDATE
524: and nvl(fnd_user.end_date,sysdate) >= sysdate;
525: exception
526: when others then

Line 523: and hz_relationships.end_date >= SYSDATE

519: and hz_relationships.subject_id = fnd_user.person_party_id
520: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
521: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
522: and hz_relationships.start_date <= SYSDATE
523: and hz_relationships.end_date >= SYSDATE
524: and nvl(fnd_user.end_date,sysdate) >= sysdate;
525: exception
526: when others then
527: v_auc_contact_id := null;

Line 2722: FROM hz_relationships

2718: v_debug_status := 'TRADING_PARTNER_CONTACT';
2719:
2720: BEGIN
2721: SELECT object_id INTO x_trading_partner_contact_id
2722: FROM hz_relationships
2723: WHERE subject_id = x_trading_partner_id
2724: AND relationship_type = 'CONTACT'
2725: AND relationship_code = 'CONTACT_OF'
2726: AND start_date < Sysdate