DBA Data[Home] [Help]

APPS.CSI_INTERFACE_PKG dependencies on CSI_IP_ACCOUNTS

Line 3821: FROM csi_ip_accounts

3817: SELECT ip_account_id,
3818: object_version_number
3819: INTO px_party_acct_tbl(l_pa_ind).ip_account_id,
3820: px_party_acct_tbl(l_pa_ind).object_version_number
3821: FROM csi_ip_accounts
3822: WHERE instance_party_id = px_party_acct_tbl(l_pa_ind).instance_party_id
3823: AND relationship_type_code = px_party_acct_tbl(l_pa_ind).relationship_type_code;
3824:
3825: EXCEPTION

Line 3835: FROM csi_ip_accounts

3831: SELECT ip_account_id,
3832: object_version_number
3833: INTO px_party_acct_tbl(l_pa_ind).ip_account_id,
3834: px_party_acct_tbl(l_pa_ind).object_version_number
3835: FROM csi_ip_accounts
3836: WHERE instance_party_id = px_party_acct_tbl(l_pa_ind).instance_party_id
3837: AND party_account_id = px_party_acct_tbl(l_pa_ind).party_account_id
3838: AND relationship_type_code = px_party_acct_tbl(l_pa_ind).relationship_type_code;
3839: EXCEPTION

Line 3848: FROM csi_ip_accounts

3844: END;
3845: ELSE
3846: SELECT object_version_number
3847: INTO px_party_acct_tbl(l_pa_ind).object_version_number
3848: FROM csi_ip_accounts
3849: WHERE ip_account_id = px_party_acct_tbl(l_pa_ind).ip_account_id;
3850: END IF;
3851: END IF;
3852: END LOOP;