DBA Data[Home] [Help]

APPS.AHL_PRD_PRINT_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 2656: FROM AHL_UE_RELATIONSHIPS

2652: SELECT unit_effectivity_id
2653: FROM AHL_UNIT_EFFECTIVITIES_B UE,
2654: (
2655: SELECT related_ue_id
2656: FROM AHL_UE_RELATIONSHIPS
2657: START WITH ue_id = c_ue_id
2658: AND relationship_code = 'PARENT'
2659: CONNECT BY ue_id = PRIOR related_ue_id
2660: AND relationship_code = 'PARENT'

Line 2682: FROM AHL_UE_RELATIONSHIPS

2678: FROM AHL_UNIT_EFFECTIVITIES_B UE,
2679: AHL_MR_HEADERS_B MRB,
2680: (
2681: SELECT related_ue_id
2682: FROM AHL_UE_RELATIONSHIPS
2683: START WITH ue_id = c_ue_id
2684: AND relationship_code = 'PARENT'
2685: CONNECT BY ue_id = PRIOR related_ue_id
2686: AND relationship_code = 'PARENT'

Line 2994: FROM AHL_UE_RELATIONSHIPS

2990: FROM AHL_UNIT_EFFECTIVITIES_B UE,
2991: AHL_MR_HEADERS_B MRB,
2992: (
2993: SELECT related_ue_id
2994: FROM AHL_UE_RELATIONSHIPS
2995: START WITH ue_id = :1
2996: AND relationship_code = ''PARENT''
2997: CONNECT BY ue_id = PRIOR related_ue_id
2998: AND relationship_code = ''PARENT''