APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on HZ_PARTIES

Line 3358: FROM hz_parties hp

3354: AND fu.User_id = V_USER_ID;
3355:
3356: Cursor Get_B2C_User IS
3357: SELECT hp.party_name
3358: FROM hz_parties hp
3359: ,fnd_user fu
3360: WHERE hp.party_type = 'PERSON'
3361: AND sysdate BETWEEN nvl(fu.start_date, sysdate-1)
3362: AND nvl(fu.end_date, sysdate+1)

Line 3370: from hz_parties hp

3366: AND fu.User_id = V_USER_ID;
3367:
3368: Cursor Get_B2B_User IS
3369: SELECT hp.party_name
3370: from hz_parties hp
3371: ,hz_relationships hr
3372: ,fnd_user fu
3373: WHERE hr.party_id = fu.customer_id
3374: AND hr.subject_id = hp.party_id

Line 3377: AND hr.subject_table_name = 'HZ_PARTIES'

3373: WHERE hr.party_id = fu.customer_id
3374: AND hr.subject_id = hp.party_id
3375: AND hr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3376: AND hp.party_type = 'PERSON'
3377: AND hr.subject_table_name = 'HZ_PARTIES'
3378: AND hr.object_table_name = 'HZ_PARTIES'
3379: AND sysdate BETWEEN nvl(fu.start_date, sysdate-1)
3380: AND nvl(fu.end_date, sysdate+1)
3381: AND fu.customer_id is not null

Line 3378: AND hr.object_table_name = 'HZ_PARTIES'

3374: AND hr.subject_id = hp.party_id
3375: AND hr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3376: AND hp.party_type = 'PERSON'
3377: AND hr.subject_table_name = 'HZ_PARTIES'
3378: AND hr.object_table_name = 'HZ_PARTIES'
3379: AND sysdate BETWEEN nvl(fu.start_date, sysdate-1)
3380: AND nvl(fu.end_date, sysdate+1)
3381: AND fu.customer_id is not null
3382: AND fu.employee_id is null