APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_VISIT_TASKS_B

Line 574: SELECT 'x' FROM ahl_visit_tasks_b

570:
571: -- Added by surrkuma for bug# 13998921 on 26-Apr-12
572: -- Check the Visit tasks for the given instance in PLANNING status
573: CURSOR check_visit_tasks_status_csr IS
574: SELECT 'x' FROM ahl_visit_tasks_b
575: WHERE visit_id = p_visit_id
576: AND instance_id = p_item_instance_id
577: AND status_code = 'PLANNING';
578:

Line 2051: AHL_VISIT_TASKS_B VT,

2047: UNION ALL
2048: SELECT SB.rule_id,
2049: SB.rule_sequence
2050: FROM AHL_SB_POSITION_RULES SB,
2051: AHL_VISIT_TASKS_B VT,
2052: AHL_UNIT_CONFIG_HEADERS UC
2053: WHERE UC.unit_config_header_id = c_uc_header_id
2054: AND SB.mc_header_id = UC.master_config_id
2055: -- take only the rules which have MRs attached to the visit

Line 2538: ahl_visit_tasks_b vt

2534: asm.organization_id,
2535: asm.relationship_id,
2536: vt.instance_id
2537: FROM ahl_schedule_materials asm,
2538: ahl_visit_tasks_b vt
2539: WHERE asm.scheduled_material_id = c_asm_id
2540: AND vt.visit_task_id = asm.visit_task_id;
2541:
2542: -- Cursor to get the UC header Id from the instance Id

Line 2584: AHL_VISIT_TASKS_B VT,

2580: UNION ALL
2581: SELECT SB.rule_id,
2582: SB.rule_sequence
2583: FROM AHL_SB_POSITION_RULES SB,
2584: AHL_VISIT_TASKS_B VT,
2585: AHL_UNIT_CONFIG_HEADERS UC
2586: WHERE UC.unit_config_header_id = c_uc_header_id
2587: AND SB.mc_header_id = UC.master_config_id
2588: -- take only the rules which have MRs attached to the visit