APPS.AHL_PRD_DF_APPR_PVT dependencies on AHL_UNIT_DEFERRALS_B

Line 47: SELECT unit_effectivity_id from ahl_unit_deferrals_b

43: l_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type;
44: l_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type;
45:
46: CURSOR unit_effectivity_id_csr(p_unit_deferral_id IN NUMBER) IS
47: SELECT unit_effectivity_id from ahl_unit_deferrals_b
48: WHERE unit_deferral_id = p_unit_deferral_id;
49:
50: l_unit_effectivity_id NUMBER;
51:

Line 1332: UPDATE AHL_UNIT_DEFERRALS_B

1328: SET approver_notes = substrb(l_error_msg,1,4000)
1329: WHERE unit_deferral_id = l_object_id
1330: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1331:
1332: UPDATE AHL_UNIT_DEFERRALS_B
1333: SET approval_status_code = 'DEFERRAL_REJECTED',
1334: object_version_number = object_version_number + 1,
1335: last_update_date = sysdate,
1336: last_updated_by = fnd_global.user_id,

Line 1353: UPDATE AHL_UNIT_DEFERRALS_B

1349: SET approver_notes = substrb(l_error_msg,1,4000)
1350: WHERE unit_deferral_id = l_object_id
1351: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1352:
1353: UPDATE AHL_UNIT_DEFERRALS_B
1354: SET approval_status_code = 'DEFERRAL_REJECTED',
1355: object_version_number = object_version_number + 1,
1356: last_update_date = sysdate,
1357: last_updated_by = fnd_global.user_id,

Line 1498: UPDATE AHL_UNIT_DEFERRALS_B

1494: SET approver_notes = substrb(l_error_msg,1,4000)
1495: WHERE unit_deferral_id = l_object_id
1496: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1497:
1498: UPDATE AHL_UNIT_DEFERRALS_B
1499: SET approval_status_code = 'DEFERRAL_REJECTED',
1500: object_version_number = object_version_number + 1,
1501: last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id,

Line 1519: UPDATE AHL_UNIT_DEFERRALS_B

1515: SET approver_notes = substrb(l_error_msg,1,4000)
1516: WHERE unit_deferral_id = l_object_id
1517: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1518:
1519: UPDATE AHL_UNIT_DEFERRALS_B
1520: SET approval_status_code = 'DEFERRAL_REJECTED',
1521: object_version_number = object_version_number + 1,
1522: last_update_date = sysdate,
1523: last_updated_by = fnd_global.user_id,