DBA Data[Home] [Help]

APPS.CSI_INTERFACE_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

Line 2908: hz_cust_account_roles hzar

2904: IF x_source_line_rec.ship_to_contact_id is not null THEN
2905: SELECT hzr.subject_id
2906: INTO x_source_line_rec.ship_to_contact_party_id
2907: FROM hz_relationships hzr,
2908: hz_cust_account_roles hzar
2909: WHERE hzar.cust_account_role_id = x_source_line_rec.ship_to_contact_id
2910: AND hzr.party_id = hzar.party_id
2911: AND hzr.subject_table_name = 'HZ_PARTIES'
2912: AND hzr.object_table_name = 'HZ_PARTIES'

Line 2920: hz_cust_account_roles hzar

2916: IF x_source_line_rec.bill_to_contact_id is not null THEN
2917: SELECT hzr.subject_id
2918: INTO x_source_line_rec.bill_to_contact_party_id
2919: FROM hz_relationships hzr,
2920: hz_cust_account_roles hzar
2921: WHERE hzar.cust_account_role_id = x_source_line_rec.bill_to_contact_id
2922: AND hzr.party_id = hzar.party_id
2923: AND hzr.subject_table_name = 'HZ_PARTIES'
2924: AND hzr.object_table_name = 'HZ_PARTIES'

Line 3023: hz_cust_account_roles hzar

3019: IF x_source_line_rec.ship_to_contact_id is not null THEN
3020: SELECT hzr.subject_id
3021: INTO x_source_line_rec.ship_to_contact_party_id
3022: FROM hz_relationships hzr,
3023: hz_cust_account_roles hzar
3024: WHERE hzar.cust_account_role_id = x_source_line_rec.ship_to_contact_id
3025: AND hzr.party_id = hzar.party_id
3026: AND hzr.subject_table_name = 'HZ_PARTIES'
3027: AND hzr.object_table_name = 'HZ_PARTIES'