APPS.AHL_FMP_PVT dependencies on AHL_MR_RELATIONSHIPS

Line 746: FROM ahl_mr_relationships

742:
743: --added for SB effectivity changes
744: CURSOR get_terminating_mr_csr(c_mr_header_id IN NUMBER) IS
745: SELECT mr_header_id
746: FROM ahl_mr_relationships
747: WHERE relationship_code = 'TERMINATES'
748: AND related_mr_header_id = c_mr_header_id;
749:
750:

Line 1414: ahl_mr_relationships mrr

1410: where MLC.mr_relationship_id = lcr.start_mr_relationship_id ) start_mr_header_id,
1411: lcr.sequence_number
1412: FROM ahl_mr_headers_b mrb,
1413: ahl_mr_loop_chain_relns lcr,
1414: ahl_mr_relationships mrr
1415: WHERE mrb.mr_header_id = c_mr_header_id
1416: AND lcr.mr_header_id(+) = mrb.mr_header_id
1417: AND mrr.related_mr_header_id(+) = mrb.mr_header_id
1418: AND mrr.relationship_code(+) = 'INITIATES';

Line 2261: FROM ahl_mr_relationships

2257: -- Added for SB effectivity enh.
2258: -- Get all parent terminating MRs
2259: CURSOR get_terminating_mr_csr(c_mr_header_id IN NUMBER) IS
2260: SELECT mr_header_id
2261: FROM ahl_mr_relationships
2262: WHERE related_mr_header_id = c_mr_header_id
2263: AND relationship_code = 'TERMINATES'; -- effective date and complete validation
2264:
2265: l_terminate_flag VARCHAR2(1) := 'N';

Line 3188: FROM ahl_mr_relationships

3184: -- MR to be processed later
3185: /*
3186: SELECT --count(distinct related_mr_header_id)
3187: count(related_mr_header_id)
3188: FROM ahl_mr_relationships
3189: WHERE EXISTS (SELECT mr_header_id
3190: FROM ahl_mr_headers_b M -- perf bug 6266738
3191: WHERE mr_header_id = related_mr_header_id
3192: AND mr_status_code = 'COMPLETE'

Line 3208: FROM ahl_mr_relationships amr

3204: AND relationship_code = 'PARENT';
3205: */
3206:
3207: SELECT count(amr.related_mr_header_id)
3208: FROM ahl_mr_relationships amr
3209: START WITH amr.mr_header_id = c_mr_header_id
3210: AND amr.relationship_code = 'PARENT'
3211: AND exists (select 'x' from ahl_mr_headers_b mr1
3212: where mr1.mr_header_id = amr.related_mr_header_id

Line 3926: FROM ahl_mr_relationships_app_v

3922:
3923: /*
3924: CURSOR get_activities(c_mr_header_id NUMBER) IS
3925: SELECT related_mr_header_id
3926: FROM ahl_mr_relationships_app_v
3927: WHERE mr_header_id = c_mr_header_id
3928: AND relationship_code = 'PARENT';
3929: */
3930: /* modified for performance fix - bug# 6511501