APPS.HXC_UPGRADE_PKG dependencies on HXC_PA_LATEST_DETAILS

Line 88: FROM hxc_pa_latest_details hpl

84: AND ht.type = 'RETRIEVAL'
85: AND ht.status = 'SUCCESS'
86: AND ht.transaction_process_id = p_retr_id)
87: AND NOT EXISTS ( SELECT 1
88: FROM hxc_pa_latest_details hpl
89: WHERE hpl.time_building_block_id = hld.time_building_block_id
90: AND hpl.object_version_number = hld.object_version_number)
91: AND hld.application_set_id IN ( SELECT application_set_id
92: FROM hxc_application_set_comps_v

Line 943: FROM hxc_pa_latest_details hpd

939: AND ht.type = 'RETRIEVAL'
940: AND ht.status = 'SUCCESS'
941: AND ht.transaction_process_id = p_ret_id )
942: AND NOT EXISTS ( SELECT 1
943: FROM hxc_pa_latest_details hpd
944: WHERE hpd.time_building_block_id = hld.time_building_block_id
945: AND hpd.object_version_number = hld.object_version_number)
946: AND hld.application_set_id IN ( SELECT application_set_id
947: FROM hxc_application_set_comps_v

Line 1329: INSERT INTO hxc_pa_latest_details

1325: END IF;
1326:
1327:
1328: FORALL i IN org_tab.FIRST..org_tab.LAST
1329: INSERT INTO hxc_pa_latest_details
1330: (business_group_id,
1331: org_id,
1332: resource_id,
1333: time_building_block_id,