APPS.HXC_UPGRADE_PKG dependencies on HXC_LATEST_DETAILS

Line 30: FROM hxc_latest_details

26:
27: CURSOR get_id
28: IS SELECT /*+ FIRST_ROWS */
29: time_building_block_id
30: FROM hxc_latest_details
31: WHERE org_id IS NULL
32: ORDER BY 1;
33:
34: -- Start

Line 50: FROM hxc_latest_details hld

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
52: FROM hxc_transaction_details htd,
53: hxc_transactions ht
54: WHERE hld.time_building_block_id = htd.time_building_block_id

Line 76: FROM hxc_latest_details hld

72: -- Bug 9394446
73: -- Added application Set condition
74: CURSOR get_pa_detail_ids(p_retr_id IN NUMBER)
75: IS SELECT hld.time_building_block_id
76: FROM hxc_latest_details hld
77: WHERE NOT EXISTS ( SELECT 1
78: FROM hxc_transaction_details htd,
79: hxc_transactions ht
80: WHERE hld.time_building_block_id = htd.time_building_block_id

Line 828: FROM hxc_latest_details hld,

824: INDEX(hta hxc_time_attributes_pk) */
825: attribute1,
826: attribute2,
827: rowidtochar(hld.rowid)
828: FROM hxc_latest_details hld,
829: hxc_time_attribute_usages hau,
830: hxc_time_attributes hta
831: WHERE hld.time_building_block_id BETWEEN p_start
832: AND p_end

Line 868: FROM hxc_latest_details hld,

864: hld.last_update_date,
865: hld.resource_type,
866: hld.comment_text,
867: tc.time_building_block_id
868: FROM hxc_latest_details hld,
869: hxc_time_building_blocks det,
870: hxc_time_building_blocks day,
871: hxc_time_building_blocks tc
872: WHERE hld.time_building_block_id BETWEEN p_start

Line 920: FROM hxc_latest_details hld,

916: hld.last_update_date,
917: hld.resource_type,
918: hld.comment_text,
919: tc.time_building_block_id
920: FROM hxc_latest_details hld,
921: hxc_time_building_blocks det,
922: hxc_time_building_blocks day,
923: hxc_time_building_blocks tc
924: WHERE hld.time_building_block_id BETWEEN p_start

Line 1005: hxc_latest_details hld,

1001: DECODE(detail.date_to, hr_general.end_of_time,NULL,'D')
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

Line 1169: UPDATE hxc_latest_details

1165: END IF;
1166:
1167:
1168: FORALL i IN orgtab.FIRST..orgtab.LAST
1169: UPDATE hxc_latest_details
1170: SET org_id = orgtab(i),
1171: business_group_id = bgtab(i)
1172: WHERE rowid = CHARTOROWID(rowtab(i));
1173: