DBA Data[Home] [Help]

APPS.AHL_SB_RULES_PVT dependencies on AHL_VISIT_TASKS_B

Line 125: AHL_VISIT_TASKS_B VT,

121: SELECT SB.rule_id,
122: SB.rule_name,
123: SB.relationship_id
124: FROM AHL_SB_POSITION_RULES SB,
125: AHL_VISIT_TASKS_B VT,
126: AHL_UNIT_CONFIG_HEADERS UC
127: WHERE UC.unit_config_header_id = c_uc_header_id
128: AND SB.mc_header_id = UC.master_config_id
129: -- take only the rules which have MRs attached to the visit