APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_TEMP_UNIT_SR_DEFERRALS

Line 605: DELETE FROM AHL_TEMP_UNIT_SR_DEFERRALS;

601:
602: -- Initialize temporary tables.
603:
604: DELETE FROM AHL_TEMP_UNIT_EFFECTIVITIES;
605: DELETE FROM AHL_TEMP_UNIT_SR_DEFERRALS;
606:
607: -- validate item instance.
608: Validate_item_instance(p_csi_item_instance_id, l_inventory_item_id,
609: l_inv_master_organization_id);

Line 2535: FROM ahl_temp_unit_SR_deferrals

2531: -- fix for bug# 6875650. Deferral date includes timestamp.
2532: --decode (affect_due_calc_flag, 'N', trunc(nvl(visit_end_date, deferral_effective_on)), trunc(nvl(visit_end_date, due_date)))
2533:
2534: decode (affect_due_calc_flag, 'N', deferral_effective_on, nvl(visit_end_date, due_date))
2535: FROM ahl_temp_unit_SR_deferrals
2536: WHERE csi_item_instance_id = p_csi_instance_id
2537: AND mr_header_id = p_mr_header_id
2538: AND object_type = 'MR'
2539: AND deferral_effective_on IS NOT NULL

Line 2773: FROM ahl_temp_unit_SR_deferrals

2769: SELECT due_date,
2770: csi_item_instance_id orig_csi_item_instance_id,
2771: mr_header_id orig_mr_header_id,
2772: visit_end_date
2773: FROM ahl_temp_unit_SR_deferrals
2774: WHERE csi_item_instance_id = p_item_instance_id
2775: AND mr_header_id = p_mr_header_id
2776: AND trunc(nvl(visit_end_date, nvl(due_date, p_last_due_date))) > trunc(p_last_due_date)
2777: AND trunc(nvl(visit_end_date, nvl(due_date, p_due_date+1))) <= trunc(p_due_date)

Line 2819: FROM ahl_temp_unit_SR_deferrals

2815: SELECT due_date,
2816: csi_item_instance_id orig_csi_item_instance_id,
2817: mr_header_id orig_mr_header_id,
2818: visit_end_date
2819: FROM ahl_temp_unit_SR_deferrals
2820: WHERE csi_item_instance_id = p_item_instance_id
2821: AND mr_header_id = p_mr_header_id
2822: AND trunc(nvl(visit_end_date, nvl(due_date, p_last_due_date))) >= trunc(p_last_due_date)
2823: AND trunc(nvl(visit_end_date, nvl(due_date, p_due_date+1))) <= trunc(p_due_date)

Line 8983: insert into ahl_temp_unit_SR_deferrals (

8979: AHL_DEBUG_PUB.Debug('Group Match flag:l_visit_status:' || l_grp_match || ':' || l_visit_status);
8980: END IF;
8981:
8982: -- insert into deferral temp table.
8983: insert into ahl_temp_unit_SR_deferrals (
8984: unit_effectivity_id,
8985: object_type,
8986: csi_item_instance_id,
8987: mr_header_id,

Line 9028: insert into ahl_temp_unit_SR_deferrals (

9024: FOR ahl_applicable_grp_rec IN ahl_applicable_grp_csr(unit_effectivity_rec.csi_item_instance_id,
9025: unit_effectivity_rec.mr_header_id)
9026: LOOP
9027: -- insert into deferral temp table.
9028: insert into ahl_temp_unit_SR_deferrals (
9029: unit_effectivity_id,
9030: object_type,
9031: csi_item_instance_id,
9032: mr_header_id,

Line 9209: insert into ahl_temp_unit_SR_deferrals (

9205: END LOOP;
9206: END IF; --l_visit_status
9207:
9208: -- Write SR UE into temporary table.
9209: insert into ahl_temp_unit_SR_deferrals (
9210: unit_effectivity_id,
9211: object_type,
9212: csi_item_instance_id,
9213: mr_header_id,

Line 9253: insert into ahl_temp_unit_SR_deferrals (

9249: FOR ahl_applicable_grp_rec IN ahl_applicable_grp_csr(ahl_ue_sr_rec.csi_item_instance_id,
9250: ahl_ue_sr_rec.mr_header_id)
9251: LOOP
9252: -- insert into deferral temp table.
9253: insert into ahl_temp_unit_SR_deferrals (
9254: unit_effectivity_id,
9255: object_type,
9256: csi_item_instance_id,
9257: mr_header_id,