DBA Data[Home] [Help]

APPS.CSI_INTERFACE_PKG dependencies on CSI_IP_ACCOUNTS

Line 3729: FROM csi_ip_accounts

3725: SELECT ip_account_id,
3726: object_version_number
3727: INTO px_party_acct_tbl(l_pa_ind).ip_account_id,
3728: px_party_acct_tbl(l_pa_ind).object_version_number
3729: FROM csi_ip_accounts
3730: WHERE instance_party_id = px_party_acct_tbl(l_pa_ind).instance_party_id
3731: AND relationship_type_code = px_party_acct_tbl(l_pa_ind).relationship_type_code;
3732:
3733: EXCEPTION

Line 3743: FROM csi_ip_accounts

3739: SELECT ip_account_id,
3740: object_version_number
3741: INTO px_party_acct_tbl(l_pa_ind).ip_account_id,
3742: px_party_acct_tbl(l_pa_ind).object_version_number
3743: FROM csi_ip_accounts
3744: WHERE instance_party_id = px_party_acct_tbl(l_pa_ind).instance_party_id
3745: AND party_account_id = px_party_acct_tbl(l_pa_ind).party_account_id
3746: AND relationship_type_code = px_party_acct_tbl(l_pa_ind).relationship_type_code;
3747: EXCEPTION

Line 3756: FROM csi_ip_accounts

3752: END;
3753: ELSE
3754: SELECT object_version_number
3755: INTO px_party_acct_tbl(l_pa_ind).object_version_number
3756: FROM csi_ip_accounts
3757: WHERE ip_account_id = px_party_acct_tbl(l_pa_ind).ip_account_id;
3758: END IF;
3759: END IF;
3760: END LOOP;