APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on HZ_PARTIES

Line 3368: FROM hz_parties hp

3364: AND fu.User_id = V_USER_ID;
3365:
3366: Cursor Get_B2C_User IS
3367: SELECT hp.party_name
3368: FROM hz_parties hp
3369: ,fnd_user fu
3370: WHERE hp.party_type = 'PERSON'
3371: AND sysdate BETWEEN nvl(fu.start_date, sysdate-1)
3372: AND nvl(fu.end_date, sysdate+1)

Line 3380: from hz_parties hp

3376: AND fu.User_id = V_USER_ID;
3377:
3378: Cursor Get_B2B_User IS
3379: SELECT hp.party_name
3380: from hz_parties hp
3381: ,hz_relationships hr
3382: ,fnd_user fu
3383: WHERE hr.party_id = fu.customer_id
3384: AND hr.subject_id = hp.party_id

Line 3387: AND hr.subject_table_name = 'HZ_PARTIES'

3383: WHERE hr.party_id = fu.customer_id
3384: AND hr.subject_id = hp.party_id
3385: AND hr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3386: AND hp.party_type = 'PERSON'
3387: AND hr.subject_table_name = 'HZ_PARTIES'
3388: AND hr.object_table_name = 'HZ_PARTIES'
3389: AND sysdate BETWEEN nvl(fu.start_date, sysdate-1)
3390: AND nvl(fu.end_date, sysdate+1)
3391: AND fu.customer_id is not null

Line 3388: AND hr.object_table_name = 'HZ_PARTIES'

3384: AND hr.subject_id = hp.party_id
3385: AND hr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3386: AND hp.party_type = 'PERSON'
3387: AND hr.subject_table_name = 'HZ_PARTIES'
3388: AND hr.object_table_name = 'HZ_PARTIES'
3389: AND sysdate BETWEEN nvl(fu.start_date, sysdate-1)
3390: AND nvl(fu.end_date, sysdate+1)
3391: AND fu.customer_id is not null
3392: AND fu.employee_id is null