DBA Data[Home] [Help]

APPS.HXC_UPGRADE_PKG dependencies on HXC_APPLICATION_SET_COMPS_V

Line 66: FROM hxc_application_set_comps_v

62: FROM hxc_pay_latest_details hpl
63: WHERE hpl.time_building_block_id = hld.time_building_block_id
64: AND hpl.object_version_number = hld.object_version_number)
65: AND hld.application_set_id IN ( SELECT application_set_id
66: FROM hxc_application_set_comps_v
67: -- Bug 12609169
68: -- Added HR here
69: WHERE time_recipient_name IN ( 'Payroll','Human Resources'))
70: ORDER BY hld.time_building_block_id ;

Line 92: FROM hxc_application_set_comps_v

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
93: WHERE time_recipient_name = 'Projects')
94: ORDER BY hld.time_building_block_id ;
95:
96:

Line 895: FROM hxc_application_set_comps_v

891: FROM hxc_pay_latest_details hpd
892: WHERE hpd.time_building_block_id = hld.time_building_block_id
893: AND hpd.object_version_number = hld.object_version_number)
894: AND hld.application_set_id IN ( SELECT application_set_id
895: FROM hxc_application_set_comps_v
896: -- Bug 12609169
897: -- Added HR here
898: WHERE time_recipient_name IN ( 'Payroll','Human Resources'))
899: ;

Line 947: FROM hxc_application_set_comps_v

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
948: WHERE time_recipient_name = 'Projects')
949: ;
950:
951: -- Bug 9790410

Line 1006: hxc_application_set_comps_v hasc,

1002: FROM hxc_upg_master_temp temp,
1003: hxc_time_building_blocks day,
1004: hxc_time_building_blocks detail,
1005: hxc_latest_details hld,
1006: hxc_application_set_comps_v hasc,
1007: hxc_retrieval_processes hrp
1008: WHERE temp.master_id = day.parent_building_block_id
1009: AND temp.master_ovn = day.parent_building_block_ovn
1010: AND day.time_building_block_id = detail.parent_building_block_id