APPS.AHL_RA_NR_PROFILE_PVT dependencies on AHL_FLEET_HEADERS_B

Line 42: FROM ahl_fleet_headers_b fhb

38:
39: CURSOR get_fleet_details(c_fleet_header_id NUMBER)
40: IS
41: SELECT fhb.operating_org_id, fhb.operations_type_code
42: FROM ahl_fleet_headers_b fhb
43: WHERE fhb.fleet_header_id = c_fleet_header_id
44: AND fhb.status_code = 'COMPLETE';
45:
46: CURSOR get_profile_ident_seqs(c_mr_header_id NUMBER)

Line 379: FROM ahl_fleet_headers_b fhb

375:
376: CURSOR get_fleet_details(c_fleet_header_id NUMBER)
377: IS
378: SELECT fhb.operating_org_id, fhb.operations_type_code
379: FROM ahl_fleet_headers_b fhb
380: WHERE fhb.fleet_header_id = c_fleet_header_id
381: AND fhb.status_code = 'COMPLETE';
382:
383: CURSOR get_profile_ident_seqs(c_mr_header_id NUMBER)

Line 809: FROM ahl_fleet_headers_b

805:
806: CURSOR check_fleet_id(c_fleet_header_id NUMBER)
807: IS
808: SELECT 'X'
809: FROM ahl_fleet_headers_b
810: WHERE fleet_header_id = c_fleet_header_id
811: AND status_code = 'COMPLETE';
812:
813: CURSOR get_operating_org_id(c_operating_org_name VARCHAR2)