DBA Data[Home] [Help]

APPS.CSI_INTERFACE_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

Line 2942: hz_cust_account_roles hzar

2938: IF x_source_line_rec.ship_to_contact_id is not null THEN
2939: SELECT hzr.subject_id
2940: INTO x_source_line_rec.ship_to_contact_party_id
2941: FROM hz_relationships hzr,
2942: hz_cust_account_roles hzar
2943: WHERE hzar.cust_account_role_id = x_source_line_rec.ship_to_contact_id
2944: AND hzr.party_id = hzar.party_id
2945: AND hzr.subject_table_name = 'HZ_PARTIES'
2946: AND hzr.object_table_name = 'HZ_PARTIES'

Line 2954: hz_cust_account_roles hzar

2950: IF x_source_line_rec.bill_to_contact_id is not null THEN
2951: SELECT hzr.subject_id
2952: INTO x_source_line_rec.bill_to_contact_party_id
2953: FROM hz_relationships hzr,
2954: hz_cust_account_roles hzar
2955: WHERE hzar.cust_account_role_id = x_source_line_rec.bill_to_contact_id
2956: AND hzr.party_id = hzar.party_id
2957: AND hzr.subject_table_name = 'HZ_PARTIES'
2958: AND hzr.object_table_name = 'HZ_PARTIES'

Line 3057: hz_cust_account_roles hzar

3053: IF x_source_line_rec.ship_to_contact_id is not null THEN
3054: SELECT hzr.subject_id
3055: INTO x_source_line_rec.ship_to_contact_party_id
3056: FROM hz_relationships hzr,
3057: hz_cust_account_roles hzar
3058: WHERE hzar.cust_account_role_id = x_source_line_rec.ship_to_contact_id
3059: AND hzr.party_id = hzar.party_id
3060: AND hzr.subject_table_name = 'HZ_PARTIES'
3061: AND hzr.object_table_name = 'HZ_PARTIES'