APPS.FUN_WF_COMMON dependencies on HZ_PARTIES

Line 788: l_role_display hz_parties.party_name%TYPE;

784: l_process_complete VARCHAR2(1);
785: l_party_id NUMBER;
786: l_index NUMBER;
787: l_role_name VARCHAR2(30) ;
788: l_role_display hz_parties.party_name%TYPE;
789: l_exp_date DATE ;
790: l_role_exists VARCHAR2(1) ;
791: l_transaction_type VARCHAR2(30);
792: l_users VARCHAR2(2000);

Line 805: FROM hz_parties hzp,

801:
802: CURSOR c_get_orgname (p_transaction_id NUMBER,
803: p_contact_type VARCHAR2) IS
804: SELECT hzp.party_name
805: FROM hz_parties hzp,
806: fun_trx_headers trx
807: WHERE hzp.party_id = DECODE(p_contact_type,'I',trx.initiator_id,
808: trx.recipient_id)
809: AND trx.trx_id = p_transaction_id;

Line 1180: FROM hz_parties p,

1176: AND role.role_name = 'FUN_ADHOC_RECI_'||p_transaction_id;
1177: -- Bug No: 5897122
1178: CURSOR c_chk_web IS
1179: SELECT 'X'
1180: FROM hz_parties p,
1181: fnd_user fu,
1182: fun_trx_headers ftrx,
1183: hz_relationships hzr,
1184: hz_org_contacts hc,

Line 1192: AND hzr.subject_table_name = 'HZ_PARTIES'

1188: AND hzr.object_id = ftrx.recipient_id
1189: AND hzr.relationship_code = 'CONTACT_OF'
1190: AND hzr.relationship_type = 'CONTACT'
1191: AND hzr.directional_flag = 'F'
1192: AND hzr.subject_table_name = 'HZ_PARTIES'
1193: AND hzr.object_table_name = 'HZ_PARTIES'
1194: AND hzr.subject_type = 'PERSON'
1195: AND hc.party_relationship_id = hzr.relationship_id
1196: AND hcr.org_contact_id = hc.org_contact_id

Line 1193: AND hzr.object_table_name = 'HZ_PARTIES'

1189: AND hzr.relationship_code = 'CONTACT_OF'
1190: AND hzr.relationship_type = 'CONTACT'
1191: AND hzr.directional_flag = 'F'
1192: AND hzr.subject_table_name = 'HZ_PARTIES'
1193: AND hzr.object_table_name = 'HZ_PARTIES'
1194: AND hzr.subject_type = 'PERSON'
1195: AND hc.party_relationship_id = hzr.relationship_id
1196: AND hcr.org_contact_id = hc.org_contact_id
1197: AND hcr.role_type = 'INTERCOMPANY_CONTACT_FOR'

Line 1219: AND rel.subject_table_name = 'HZ_PARTIES'

1215: 'I',trx.initiator_id)
1216: AND rel.relationship_code = 'CONTACT_OF'
1217: AND rel.relationship_type = 'CONTACT'
1218: AND rel.directional_flag = 'F'
1219: AND rel.subject_table_name = 'HZ_PARTIES'
1220: AND rel.object_table_name = 'HZ_PARTIES'
1221: AND rel.subject_type = 'PERSON'
1222: AND SYSDATE BETWEEN NVL(rel.start_date, SYSDATE -1)
1223: AND NVL(rel.end_date, SYSDATE + 1)

Line 1220: AND rel.object_table_name = 'HZ_PARTIES'

1216: AND rel.relationship_code = 'CONTACT_OF'
1217: AND rel.relationship_type = 'CONTACT'
1218: AND rel.directional_flag = 'F'
1219: AND rel.subject_table_name = 'HZ_PARTIES'
1220: AND rel.object_table_name = 'HZ_PARTIES'
1221: AND rel.subject_type = 'PERSON'
1222: AND SYSDATE BETWEEN NVL(rel.start_date, SYSDATE -1)
1223: AND NVL(rel.end_date, SYSDATE + 1)
1224: AND c.party_relationship_id = rel.relationship_id