APPS.HXC_UPGRADE_PKG dependencies on HXC_PAY_LATEST_DETAILS

Line 47: -- Cursor to pick up Payroll's details which are not there in hxc_pay_latest_details.

43:
44: -- Bug 9394446
45: -- Added application Set condition
46:
47: -- Cursor to pick up Payroll's details which are not there in hxc_pay_latest_details.
48: CURSOR get_pay_detail_ids(p_retr_id IN NUMBER)
49: IS SELECT hld.time_building_block_id
50: FROM hxc_latest_details hld
51: WHERE NOT EXISTS ( SELECT 1

Line 62: FROM hxc_pay_latest_details hpl

58: AND ht.type = 'RETRIEVAL'
59: AND ht.status = 'SUCCESS'
60: AND ht.transaction_process_id IN (p_retr_id, -1))
61: AND NOT EXISTS ( SELECT 1
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

Line 891: FROM hxc_pay_latest_details hpd

887: AND ht.type = 'RETRIEVAL'
888: AND ht.status = 'SUCCESS'
889: AND ht.transaction_process_id IN (p_ret_id,-1))
890: AND NOT EXISTS ( SELECT 1
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

Line 1238: INSERT INTO hxc_pay_latest_details

1234: END IF;
1235:
1236:
1237: FORALL i IN org_tab.FIRST..org_tab.LAST
1238: INSERT INTO hxc_pay_latest_details
1239: (business_group_id,
1240: org_id,
1241: resource_id,
1242: time_building_block_id,