DBA Data[Home] [Help]

APPS.CSM_PARTY_DATA_EVENT_PKG dependencies on CSI_I_VERSION_LABELS

Line 101: TYPE ver_lab_Tab IS TABLE OF csi_i_version_labels.version_label%TYPE INDEX BY BINARY_INTEGER;

97: TYPE l_counter_prop_val_tbl_type IS TABLE OF csm_counter_prop_values_acc.counter_prop_value_id%TYPE INDEX BY BINARY_INTEGER;
98: TYPE l_counter_prp_id_tbl_type IS TABLE OF csm_counter_properties_acc.counter_property_id%TYPE INDEX BY BINARY_INTEGER;
99: TYPE l_relationship_id_tbl_type IS TABLE OF HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE INDEX BY BINARY_INTEGER;
100: TYPE l_direct_flag_tbl_type IS TABLE OF HZ_RELATIONSHIPS.DIRECTIONAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
101: TYPE ver_lab_Tab IS TABLE OF csi_i_version_labels.version_label%TYPE INDEX BY BINARY_INTEGER;
102:
103: l_party_id_tbl l_party_id_tbl_type;
104: l_user_id_tbl l_user_id_tbl_type;
105: l_party_site_id_tbl l_party_site_id_tbl_type;

Line 192: , csi_i_version_labels civ

188: , CIR.OBJECT_ID
189: FROM csi_item_instances cii
190: , csm_party_sites_acc cpsa
191: , csm_party_assignment tcpa
192: , csi_i_version_labels civ
193: , CSI_II_RELATIONSHIPS CIR
194: WHERE cii.location_id = cpsa.party_site_id
195: AND cpsa.party_id = tcpa.party_id
196: AND cpsa.user_id = tcpa.user_id

Line 221: , csi_i_version_labels civ

217: , CIR.OBJECT_ID
218: FROM csi_item_instances cii
219: , csm_party_assignment cpa
220: , hz_locations hz
221: , csi_i_version_labels civ
222: , CSI_II_RELATIONSHIPS CIR
223: WHERE cii.owner_party_id = cpa.party_id
224: AND cii.location_id = hz.location_id
225: AND cii.location_type_code = 'HZ_LOCATIONS'